What is wrong??
Can anyone tell me why my autofilter is not working??
When the dates are entered, nothing is filtered at all? Any ideas?? Thanks Wil -- Message posted from http://www.ExcelForum.com |
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/ . |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com