Thread: What is wrong??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default What is wrong??


are yuo doing this in code? you don't give us much to go
on.


Selection.AutoFilter Field:=2, Criteria1:="25/11/03"

Try setting the field my using the macro recorder &
selecting a date from the criteria dropdown. Examining
the resultant code may give you a clue as to what the
issue might be.It might be that your PC date settings
don't match what you're entering



-----Original Message-----
Can anyone tell me why my autofilter is not working??

When the dates are entered, nothing is filtered at all?

Any ideas??

Thanks

Will


---
Message posted from http://www.ExcelForum.com/

.