| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| Starting/Stopping Worksheet Event Code | Excel Discussion (Misc queries) | |||
| Stopping Calculation | Excel Discussion (Misc queries) | |||
| Stopping calculation once it starts | Excel Discussion (Misc queries) | |||
| Stopping chart line where 1 of 2 columns of data in calculation is blank | Charts and Charting in Excel | |||
Linear Mode
