Stopping Auto calculation in Part of a Worksheet

  • Thread starter Thread starter Mhukki
  • Start date Start date
M

Mhukki

Freezing Autocalculation in Part of a Worksheet and allowing the other Part
of the worksheet to Auto calculate.
 
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---
 
Back
Top