Filter between two named ranged dates

[wacky_diva]

Hi all,
I can't work out for the life of me why this simple code isn't working.
Any suggestions?

Just rying to filter between the two named range dates set at the beginning of the code.

Please Login or Register  to view this content.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[wacky_diva]

Hi AlphaFrog,
I am getting a compile error: object required.

[wacky_diva]

I have removed the "set' at the beginning and now the code is running.
It is behaving strangely however, the filter is returning 0 results until I go into the filter again and run the settings already in the filter. Additionally it is applying dates in the named range in an American date format. The format I am using is dd/mm/yyyy.

Do you run into problems like this often with different date formats?