Resetting AutoFilter

[longbow007]

Hello, could some please view my code as it runs rather slow. Is there a better way to achieve the same results?

Please Login or Register  to view this content.

Any help would be greatly appreciated,

Kind regards,

Chris

[DonkeyOte]

Chris, you could remove the AutoFilter in full and then Re-Apply, ie:

Please Login or Register  to view this content.

As for why your code is slow... well remember that toggling visibility of rows is a Volatile action (partly due to Subtotal function etc...), this means that whenever you adjust visibility of rows by altering the filters all of your calculations that include Volatile functions or refer to cells containing Volatile Functions will recalculate - what are Volatile functions ? see link in sig.

So if you have lots of Volatiles you may want to think about altering the calculation mode of the Application prior to altering the Auto Filter and then resetting calculation to it's original state upon completion.

[romperstomper]

I think you want the ShowAllData method

[DonkeyOte]

R, presumably the point re: calculation remains however ?

[romperstomper]

Yep - though resetting once should be a lot faster than going one by one.

[longbow007]

Thanks DonkeyOte and romperstomper for all your great help and advice - really appreciated