Stopping Auto calculation in Part of a Worksheet
 

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

Stopping Auto calculation in Part of a Worksheet
 

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---

--
RyGuy


"Mhukki" wrote:

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