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