Auto Filter
I have used a Input Form which collects Date Range. In execute event I have
written following code
Selection.AutoFilter Field:=20,
Criteria1:="=" & Txt_From,
Operator:=xlAnd,
Criteria2:="<=" & Txt_To
I dont find any mistake in the above code. Data is entering in the custom
filter. But filter is not doing its work. Further Date format which I Enter
is DD/MM/YY.
I have applied filter on several other fileds and it works. But filter on
Date fields doesnot work.
Please send your valuable solution.
Regards
Grisha Jose
|