| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Criteria not filtering when using NOW()
Hi,
I have this line of code. Selection.AutoFilter Field:=Range("Note1").Column, Criteria1:="<=" & Format(Now(), "dd/mm/yyyy") I want to filter anything dated today or prior. It's not working - every line is being filtered out. When I drop down the autofilter button for the column, and go to 'Custom' I can see the correct date is in the dialog box, and the filter works when I press OK through it. Anyone know why this isn't working? Cheers Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is autofilter only filtering up to # of rows in prev column? | Excel Discussion (Misc queries) | |||
| Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
| Autofilter Not Filtering Properly | Excel Discussion (Misc queries) | |||
| AutoFilter only filtering first 1000 | Excel Discussion (Misc queries) | |||
| Filtering out dates using autofilter | Excel Programming | |||
Threaded Mode
