MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
I am using:
Excel version 2016 (16.0) (Build 13628.20380) 32 bit
Windows 10 Pro version 2009 (20H2) (Oct 2020) Build 19042 64 bit
i am trying to write vba code to filter on multiple non consecutive dates, but I haven't been successful.
so I did what I thought should be very simple:
I have a worksheet with the below data starting in cell(1,1) (rows with date entries are formatted as m/d/yyyy):
When I use the macro recorder to create an autofilter macro, it creates it as:
and the data is correctly filtered. but when I remove the filter and then manually run the macro, it gives error:
Description: AutoFilter method of Range class failed
I have tried multiple other ways but can't get any autofilter with dates and array to work.
I have read MANY googled items, but haven't found the solution.
Anyone know what's wrong ?