Thread: Auto Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grisha Jose Grisha Jose is offline
external usenet poster
 
Posts: 1
Default 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