upobDaPlaya
asked on
How do I suspend auto cals in MS Excel when running a VBA module
In a VBA module I turn off auto calculations at the beginning of the code. At the end I turn it back on, but this is problematic as when I turn it back on in the code it re-ca calculates and takes forever since I have a lot of CountIFS and SUMIFS...
Any suggestions...
I
Any suggestions...
I
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you...
ASKER
Flyster,
In the interim I will give your suggestion a shot.