| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter vba dont show filtered data
When i run my autofilter code, range with autofilter is empty ( except autofilter columns ). Then if i select "(Custom...)" in autofilter list i can see correct dates in criteria fields and after i cick OK, Autofilter filter and show correct rows.
my autofilter code; Range("a1").AutoFilter Field:=4, Criteria1:="=27.5.2004" , Operator:=xlAnd, Criteria2:="<=3.6.2004" I'm using Excel 97 and Windows XP Pro |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts dont refresh to show changes to data sheet | Charts and Charting in Excel | |||
| graph, data lables value, dont show zero values | Charts and Charting in Excel | |||
| Autofilter and count on filtered data | Excel Worksheet Functions | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
| Autofilter with vba wont dispay filtered data | Excel Programming | |||
Threaded Mode
