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. |
All times are GMT +1. The time now is 03:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com