| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter with vba wont dispay filtered data
When i run autofilter code, range with autofilter is empty! but if i click "(custom...)" in autofilter list and click OK, autofilter shows right values.
my Autofilter code; Range("a1").AutoFilter Field:=4, Criteria1:="=27.5.2004", Operator:=xlAnd, Criteria2:="<=3.6.2004" i'm using Excel 97 with Win XP Pro |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter with vba wont dispay filtered data
Try
Range("a1").AutoFilter Field:=4, Criteria1:="=" & DateSerial(2005,5,27), _ Operator:=xlAnd, Criteria2:="<=" & DateSerial(2004,6,3) -- Regards, Tom Ogilvy "PPesola" wrote in message ... When i run autofilter code, range with autofilter is empty! but if i click "(custom...)" in autofilter list and click OK, autofilter shows right values. my Autofilter code; Range("a1").AutoFilter Field:=4, Criteria1:="=27.5.2004", Operator:=xlAnd, Criteria2:="<=3.6.2004" i'm using Excel 97 with Win XP Pro |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named data series won't dispay in Excel 2007 | Charts and Charting in Excel | |||
| Autofilter and count on filtered data | Excel Worksheet Functions | |||
| Way to display filtered results from more than one autofilter per | Excel Worksheet Functions | |||
| Autofilter: Better contrast colour on arrow on filtered data | Excel Discussion (Misc queries) | |||
| Selecting Filtered records only when AutoFilter is on | Excel Programming | |||
Linear Mode
