(Solved) – VBA Macros – AutoFilter Method [closed]

  • by
(solved)-–-vba-macros-–-autofilter-method-[closed]

I have to filter some dates using excel VBA code. like one excel file contains past and future dates.
Daily activity, I have to filter past dates as well as current date then day after tomorrow.

like i.e: Today date 2019-12-26

2019-12-24
2019-12-25
2019-12-26
2019-12-27
2019-12-28

I have to filter all past dates to till date then day after tomorrow. in this case, excel vba does only filter this values

2019-12-24
2019-12-25
2019-12-26
2019-12-27 not 2019-12-28. 

I just provide 5days but that excel date container 2018 to 2020 dates.

Leave a Reply

Your email address will not be published. Required fields are marked *