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?

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?