Recorded Macro for Excel Table doesn't work when run again

Hi,

I tried to record a macro with Excel.

It has to select a table, sort and filter values based on date - simple operation.

The macro is recorded properly.

But, when I tried to run recorded macro again it doesn't run the way it should. It filters all data and doesn't display any data.

I have not amended any code on the macro after I have recorded it and no changes on the excel data either. But it simply doesn't work.

Am I missing something in here.

Please Login or Register  to view this content.

I have attached the excel file and also the screen shots for what I achieved with the macro running as well.

cannot replicate your issue. Macro works fine for me on your unfiltered table. Filters properly.

Originally Posted by alansidman

cannot replicate your issue. Macro works fine for me on your unfiltered table. Filters properly.

It seems that earlier file wasn't saved properly, so wrong file got uploaded.

Can you please check now.

What happens with...

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.