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 |
All times are GMT +1. The time now is 10:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com