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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to turn off autofilter 2
Pasting cell contents into a macro 1
autofilter and vba 3
problem with a macro autofilter to delet rows 6
Excel Monthly Spread sheet. 12
Excel 2013: AutoFilter and SUM() 1
deleting row using macro 6
NOW function in Autofilter 4

Back
Top