Dave Hawley - VBA Date Filter - Still Not Working
Posted by JAF on March 01, 2001 1:55 AM
Thanks for your suggestion as to a solution for my VBA Date Filter problem, but I've tried what you suggested and Excel is still not running the filter correctly.
The code I'm using is:
Dim MyDate As String
MyDate = DateSerial(2001, 1, 24)
Selection.AutoFilter Field:=1, Criteria1:=MyDate
... which should return entries which have a date of 24/01/2001, is still returning no records, even though there are entries in the column of that value.