using macros to autofilter using CURRENT date

[brian97]

What is the macro I need for autofiltering using the current date?
I want the macro to update every day and know the date.

 

[Rick Sanderson]

|| What is the macro I need for autofiltering using the current date?
|| I want the macro to update every day and know the date.
||
||
|| ---
||

typing =now() will enter the current date into a cell.

so you could have a cell containing this function and a autofilter
referencing this cell, assuming the dates are stored in col A

Worksheets("sheet1").Range("a1").Select
Selection.AutoFilter Field:=1, Criteria1:=*cell reference here*

Rick