Calculation state

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I believe that Application.Calculate waits until the recalculation is
complete before passing control back to the next line of code in a VBA
routine. Call it right after you are finished putting all of the inputs in
their cells. Capture and store all input and output values (copy and
paste-special-cells) to a separate log worksheet before beginning the next
iteration.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop until Calculationstate = xldone 1
Help on writing class module 4
CalculateFullRebuild vs CalculateFull 3
Recalculate a worksheet following an autofilter selection. 1
Need Calculations Done Event 1
force recalculation of function 5
Calculation Satus for a Sheet 2
Force Recalc 3

Back
Top