Calculation state
I need to recalculate a worksheet many times using VBA to record the input &
output values from the model in the worksheet. I need to detect when a
recalculation is finished before initiating the next one. I tried using
If Application.CalculationState = 2 Then ... and
If Application.CalculationState = xlDone Then...
without success. Does anyone have a suggestion for this problem.
|