G
Guest
Guest
Hi, question:
Here is my code:
Sub AutoFilter()
Sheets("Feb 18 - Feb 22").Select
Selection.AutoFilter
ActiveWindow.LargeScroll ToRight:=-1
Selection.AutoFilter Field:=1, Criteria1:="02/20/02"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter
End Sub
In the bold section ("02/20/02") my macro does an auto filter by that date. I want the date to reflect TODAY'S date, but I can't get it to work. Instead of "02/20/02", I've tried:
Today
Format(Today, "mm/dd/yy")
and tried linking it to a cell that contains today's date, but none of these work...
Some help! please!
Thanks
Here is my code:
Sub AutoFilter()
Sheets("Feb 18 - Feb 22").Select
Selection.AutoFilter
ActiveWindow.LargeScroll ToRight:=-1
Selection.AutoFilter Field:=1, Criteria1:="02/20/02"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter
End Sub
In the bold section ("02/20/02") my macro does an auto filter by that date. I want the date to reflect TODAY'S date, but I can't get it to work. Instead of "02/20/02", I've tried:
Today
Format(Today, "mm/dd/yy")
and tried linking it to a cell that contains today's date, but none of these work...
Some help! please!
Thanks