autofilter problem with date values

[Simon Sunke]

hi

I use excel 2003 and want to autofilter a column which contains date values.
autofilter applyed by vba do not work at all, no data will be displayed,
even if I record a makro when applying the filter in excel...

Thanks a lot
Simon

 

[Simon Sunke]

by the way, I use the following piece of code to apply the filter in vba:
Range("A:A").AutoFilter , Field:=1,
Criteria1:=CStr(Format(Range("A2").Value, Range("A2").NumberFormat))
(after searching through past threads)

Simon

 

[Tom Ogilvy]

Range("A:A").AutoFilter Field:=1, _
Criteria1:="=" & Range("A2").Value2

if your column A contains time as well, you will have to use a criteria like

yesterday, < tomorrow

--
Regards,
Tom Ogilvy

 

[Simon Sunke]

if your column A contains time as well, you will have to use a criteria
like
well, that doesen't work either

Simon