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/
.