Hi,
I have a macro that I want to autofilter a sheet of data with the criteria being Todays date.
What criteria should I put in the line of code below and what format should the data in the column be in?
Selection.AutoFilter Field:=11, Criteria1:= ???
I have tried putting TODAY and NOW in there but it doesnt work.
Thanks for any help
I have a macro that I want to autofilter a sheet of data with the criteria being Todays date.
What criteria should I put in the line of code below and what format should the data in the column be in?
Selection.AutoFilter Field:=11, Criteria1:= ???
I have tried putting TODAY and NOW in there but it doesnt work.
Thanks for any help