Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date filter for yesterday and today
Hi,
sorry I guess thats very easy for you but I dont know how to do it. I would like to filter for yesterday and today. At the moment I am only filtering for yesterday: ActiveSheet.Range("$A$1:$CL$8641").AutoFilter Field:=1, Criteria1:= _ xlFilterYesterday, Operator:=xlFilterDynamic What do I have to add so that that it filters for both days? Thanks Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File saved yesterday is blank today, how do I retrieve? | New Users to Excel | |||
Change Date code to yesterday/day before ,,,, | Excel Programming | |||
Filter and Delete all rows with a date greater than or = today | Excel Programming | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
worked yesterday- doesn't work today | Excel Programming |