I am currently using the following code to filter column 16 by the current date. What I would like to do is filter by today and yesterday. How do I rewrite this to do this and what is the =Array(0, do? I would like to be able to write these...
Like filter by today, yesterday, and the day before that. (have three days)
Another tough one for me is, filter by today and the fourth day back (2 days)
ActiveSheet.UsedRange.AutoFilter Field:=16, Operator:= _
xlFilterValues, Criteria2:=Array(0, DateValue(Now))
I am having some issues understanding whether i should use NOW() or if I should grab what the current day of the week is?