| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace state names with state code abbreviations | Excel Worksheet Functions | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| State Map | Excel Discussion (Misc queries) | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| Detecting Calculation State | Excel Programming | |||
Linear Mode
