Make Excel 'remember' filters?

Hi There,

was wondering if someone could tell me how to make Excel 'Remember' what filters were on before a macro is run?

We have a sheet and people are setting their own filters all the time but when it comes time to run the macro, it needs to remove their filters and set its own. Ideally I would like it to return the previous filters so everyone is happy!

Any help is appreciated.

Thanks

John

if you have a predefined filter set you could get your macro to reset all the filters and then re-filter the data how you want it and then run its macro after all this has been accomplished.

if ya need any help post an example of the spreadsheet.

hth

Hi Justin,

thanks for the reply. Unfortunately, the filters will most likely be different every time the macro is run so that wouldn't work.

John

Hi,
maybe you can create CustomView and (after your macro) restore filters from this view.

Please Login or Register  to view this content.

Jarek

Hi Jarek,

finally had chance to come back to this and test.

Works perfect so thanks very much for your help.

John