Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom filter date using VB
Hi
I am running a macro to select rows from data using filter of certain fields. It works fine for the fields where I have to searching for specific text eg Selection.AutoFilter Field:=10, Criteria1:="=*" & strReportSponsor & "*" however I am trying to filter a date field to say where the date is less then a particular date Selection.AutoFilter Field:=13, Criteria1:="<=" & ReportDueBy the macro enters the less than date in the filter but it does not select any rows. When I select the filter manually I can see the date has been entered by the macro and then when I manually select "ok" again it works fine. Any idea why the macro is not returning any rows? -- Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Filter? | Excel Discussion (Misc queries) | |||
Custom Filter | Excel Worksheet Functions | |||
Custom Filter | New Users to Excel | |||
Custom Filter | Excel Discussion (Misc queries) | |||
Custom Filter Problem | Excel Discussion (Misc queries) |