Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate
I have a spreadsheet with a lot of formulas in it. In order to run the macro
faster, I turn the recalc to manual, run my process, and turn the recalc back to automatic. In a loop within the code, however, I have to change the value of a cell which will create the need for a calculate statement to be issued. My question, if I issue the calculate statement, do I need to pause so that all cells can be recalculated or can I assume that cells that I pick up values for and assign to variables will be calculated? How long do I pause? How can I know how long to pause programatically? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate
Your process should continue automatically once the recalc is completed,
therefore a pause shouldn't be necessary. "Mike H." wrote: I have a spreadsheet with a lot of formulas in it. In order to run the macro faster, I turn the recalc to manual, run my process, and turn the recalc back to automatic. In a loop within the code, however, I have to change the value of a cell which will create the need for a calculate statement to be issued. My question, if I issue the calculate statement, do I need to pause so that all cells can be recalculated or can I assume that cells that I pick up values for and assign to variables will be calculated? How long do I pause? How can I know how long to pause programatically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate time does not calculate | Excel Discussion (Misc queries) | |||
Activesheet.Calculate failing to calculate | Excel Programming | |||
Calculate | Excel Programming | |||
Calculate only if... | Excel Discussion (Misc queries) | |||
Macro that hide or unhide and not calculate or calculate | Excel Programming |