Hi,
I have created a protected sheet, when any of my macros run I remove the autofliter, because it can impact my code and the results - it's a necessity.
However, it's super engraging actually, because users use the filters extensively and every time they run a macro all their filter criteria is removed and they have to put it back - super cumbursome.
Therefore, I would like:
1. Before removing the filter I would like to test the filter criteria.
2. Keep that filter criteria.
3. Reapply the filter w/ the last criteria.
Does anyone know how to do that?
Thanks!!!
Bookmarks