What is wrong??

  • Thread starter Thread starter willroy
  • Start date Start date
W

willroy

Can anyone tell me why my autofilter is not working??

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

Any ideas??

Thanks

Wil
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter problem 7
Weird ignoring of one item in a loop 5
remembering the same filtering criteria 13
excel date format problem 1
Code to filter a database displays no rows at all 2
Problem with date formatting 5
Please explain this AutoFilter procedure 6
Is it possible to ask an autofilter what is current filtered criteriais? 1

Back
Top