Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilter problem | Excel Discussion (Misc queries) | |||
Problem with AutoFilter | Excel Programming | |||
Problem using Autofilter | Excel Programming | |||
AutoFilter VBA Problem | Excel Discussion (Misc queries) | |||
AutoFilter Problem | Excel Programming |