I have the below code:

With Sheets("Stores")

.Cells.AutoFilter Field:=1,
Criteria1:=Sheets("Worksheet").Range("C1").Value
.Cells.AutoFilter Field:=4,
Criteria1:=Sheets("Worksheet").Range("Q2").Value

End With

The first autofilter works fine.

The 2nd doesn't. Field 4 is a column (D) of dates. Worksheet.Range("Q2")
is a date. The cells are formatted the same. I can find a cell in column D
with the same value as worksheet.range("Q2") and use an If statement to
confirm the two values are equal. ???


--
Thanks
Shawn