Stopping Auto calculation in Part of a Worksheet

M

Mhukki

Freezing Autocalculation in Part of a Worksheet and allowing the other Part
of the worksheet to Auto calculate.
 
R

ryguy7272

Typically, once the macro starts, it just runs through the whole routine,
executing all instructions, in order, etc., etc. Depending on what you are
are doing, you MAY be able to pause the macro for a predefined period of time:

Application.OnTime Now + TimeValue("00:00:04"), ...what you want to do
next goes here...


Regards,
Ryan---
 
Top