Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
advanced filter date criteria
Hi
My advanced filter works manually but not in macro It is a criteria issue as column headings work I am trying to filter data where ship date is <= todays date +28 Columns("g:k").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ "m1:m2"), CopyToRange:=Range("p1" _ ), Unique:=False where m1 = ShipDate and m2 = <=15/03/2010 this works manually but not in macro but if replace m2 with a date it works therefore how do i write for less than and equal to Thank you Tina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
advanced filter date criteria
Hi
I worked out date has to be mm/dd/yy format Sorry if wasted anybodies time Tina "tina" wrote: Hi My advanced filter works manually but not in macro It is a criteria issue as column headings work I am trying to filter data where ship date is <= todays date +28 Columns("g:k").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ "m1:m2"), CopyToRange:=Range("p1" _ ), Unique:=False where m1 = ShipDate and m2 = <=15/03/2010 this works manually but not in macro but if replace m2 with a date it works therefore how do i write for less than and equal to Thank you Tina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criteria for Advanced Filter HELP | New Users to Excel | |||
Advanced filter criteria | Excel Discussion (Misc queries) | |||
Advanced filter criteria for < | Excel Programming | |||
Advanced filter criteria | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |