View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PPesola PPesola is offline
external usenet poster
 
Posts: 5
Default 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