date filter for yesterday and today

R

Riensn

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
 
Top