using macros to autofilter using CURRENT date

  • Thread starter Thread starter brian97
  • Start date Start date
B

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.
 
|| What is the macro I need for autofiltering using the current date?
|| I want the macro to update every day and know the date.
||
||
|| ---
|| Message posted

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
 
Back
Top