Filter a date

[mattress58]

I am filtering and I can get this to work

This works:

Please Login or Register  to view this content.

but when I reference a range with a date instead of it in the code like above it filters with no results

Please Login or Register  to view this content.

[davesexcel]

Where is range("A4")
Usually I would set the criteria as a variable.

Please Login or Register  to view this content.

If this doesn't work, then attach a sample workbook.