View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geen geen is offline
external usenet poster
 
Posts: 1
Default Autofilter Question

Good day,

I have a workbook with a sheet named 'Download'
On this sheet i want to filter column C
When i record what i want to happen i get the following code :
Sheets("Download").Select
Selection.AutoFilter Field:=3, Criteria1:="=1-1-2003", Operator:=xlAnd,
Criteria2:="<31-1-2003"
But when i run it, i get nothing selected.
What goes wrong??

Tia Mark