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.
--
Regards,
Bill Renaud