Table ListObject Filter

[efernandes67]

Hi,

See attached file.

I created a macro to filter the table based on two criteria and everything seemed ok.
When I tried to run the macro step-by-step, I noticed that I can't see the filtered records!

What do I have to to make it work as when I recorded the macro?

Regards,
Elio Fernandes

[romperstomper]

You can use US format:

Please Login or Register  to view this content.

[efernandes67]

Hi romperstomper,

It works, but I don't understand why I can't use the "dd/mm/yyyy" format!!!

Regards,
Elio Fernandes

[romperstomper]

VBA has always been US-centric and filters and dates have always been problematic in code. Just one of those Excel things that keep us on our toes.