Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |