Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why won't it work when I use VBA to set autofilter criteria to ce.
Below is an example of what I had programmed for a custom autofilter. The
cells in the criteria contain dates. When I run the Macro it hides all the data. However if I then go into the custom filter manually the dates are already entered in the criteria and I just have to press OK for the filter to work. Is there a way around having to do this manually or can excel not handle this sort of functionality? Dim sStartDate As String Dim sEndDate As String Dim sBottomRow As String sStartDate = Sheets("Data").Cells(6, 2).Value sEndDate = Sheets("Data").Cells(6, 4).Value sBottomRow = CStr(Sheets("Data").Range("B8").End(xlDown).Row) Selection.AutoFilter Field:=8, Criteria1:="=" & sStartDate, Operator:= _ xlAnd, Criteria2:="<=" & sEndDate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter doesn't work | Excel Discussion (Misc queries) | |||
Autofilter(Top 10...): What does it do? How does it work? | Excel Discussion (Misc queries) | |||
AutoFilter Criteria VBA | Excel Programming | |||
VBA Autofilter Criteria | Excel Programming | |||
Help: Autofilter doesn't work | Excel Programming |