Tom,

Cool - that works perfectly.

I learned something - my day has meaning! :-)

Thanks very much

Pete

"Tom Ogilvy" wrote:

Generally this is because VBA uses US English formatted dates (mdy) and your
dates are in dmy. Try switching them to mdy and see if it works.

--
Regards,
Tom Ogilvy


"Peter Rooney" wrote in message
...
Good afternoon, all

I recorded the following action, to filter my databae to show rows whe the
Date field contained a date between 21/10/05 and 20/11/05.

Sub Macro7()
Selection.AutoFilter Field:=1, Criteria1:="=21/10/2005",
Operator:=xlAnd _
, Criteria2:="<=20/11/2005"
End Sub


As I recorded, the filter operation worked OK, but when I remove the
filter,
then run the macro again, the database filters out ALL rows so that only
the
firld headers are displayed.
Can anyone suggest why?

Thanks in advance

pete