| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show 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 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show filtered data
Thanks Tom, but it didnt work :(
"Tom Ogilvy" wrote: 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 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show filtered data
Did you correct my typo. I had 2005 in the first critera - change it to
2004 (nothing would match the criteria I set). Other than that, try turning on the macro recorder and recording while you do it manually, but I have good success with what I suggested. -- Regards, Tom Ogilvy "PPesola" wrote in message ... Thanks Tom, but it didnt work :( "Tom Ogilvy" wrote: 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 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show filtered data
Yep. i fixed typo. There must be something wrong with the Cell Format and date column, because if i try to autofilter other column that contains numbers only, code works.
"Tom Ogilvy" wrote: Did you correct my typo. I had 2005 in the first critera - change it to 2004 (nothing would match the criteria I set). Other than that, try turning on the macro recorder and recording while you do it manually, but I have good success with what I suggested. -- Regards, Tom Ogilvy "PPesola" wrote in message ... Thanks Tom, but it didnt work :( "Tom Ogilvy" wrote: 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 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show filtered data
There is by definition. The autofilter has problems with dates when set
from VBA if the date format of the region (of that verion) uses non US english convention (mm/dd/yyyy). Using serial numbers usually helps. Numbers are not a problem usually. -- Regards, Tom Ogilvy "PPesola" wrote in message ... Yep. i fixed typo. There must be something wrong with the Cell Format and date column, because if i try to autofilter other column that contains numbers only, code works. "Tom Ogilvy" wrote: Did you correct my typo. I had 2005 in the first critera - change it to 2004 (nothing would match the criteria I set). Other than that, try turning on the macro recorder and recording while you do it manually, but I have good success with what I suggested. -- Regards, Tom Ogilvy "PPesola" wrote in message ... Thanks Tom, but it didnt work :( "Tom Ogilvy" wrote: 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 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show filtered data
PPesola,
Try, Range("A1").AutoFilter Field:=4, Criteria1:="=" & cdbl(DateSerial(2004,5,27)), _ Operator:=xlAnd, Criteria2:="<=" & cdbl(DateSerial(2004,6,3)) Cecil "PPesola" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter vba dont show filtered data
Thanks Cecil, it works!!!
"Cecilkumara Fernando" wrote: PPesola, Try, Range("A1").AutoFilter Field:=4, Criteria1:="=" & cdbl(DateSerial(2004,5,27)), _ Operator:=xlAnd, Criteria2:="<=" & cdbl(DateSerial(2004,6,3)) Cecil "PPesola" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
