Macro to run autofilter to pick out data between two dates

[kjg]

I am having trouble with the following macro,

Please Login or Register  to view this content.

When I press F8 and step through the macro, the StartDate and EndDate both seem to populate correctly.

The macro seems to go through the motions but returns NO results, unlike the recorded macro.

Could someone please shine a little light as to where I'm going wrong?

Also, suggestion for macro code to "Clear Filter"

Thanks
Keith

[ihmha]

I found the base for the filter below on stackoverflow.

As it states in the thread dates are tricky.
When I ran your code on my machine it was changing the date format from '02/01/2013' to '01/02/2013'.
The solution is to filter the date as a real number, but it must be a date and not a string.

Please Login or Register  to view this content.

[kjg]

Hi Ihmha,
Thank you for your reply, I have inserted the code you posted and adjusted my macro and it is working "Perfectly"


Cheers
Keith