Autofilter with vba wont dispay filtered data

P

PPesola

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
 
T

Tom Ogilvy

Try

Range("a1").AutoFilter Field:=4, Criteria1:=">=" & DateSerial(2005,5,27), _
Operator:=xlAnd, Criteria2:="<=" & DateSerial(2004,6,3)

--
Regards,
Tom Ogilvy

PPesola said:
When i run autofilter code, range with autofilter is empty! but if i click
Click to expand...
"(custom...)" in autofilter list and click OK, autofilter shows right
values.
my Autofilter code;
Range("a1").AutoFilter Field:=4, Criteria1:=">=27.5.2004",
Click to expand...
Operator:=xlAnd, Criteria2:="<=3.6.2004"
 
Top