| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SheetChange event starts before .calculate finished
Hi Nils,
Any idea how to force Excel to complete the calculation of the changed range? Try setting Application.Interactive = False before the .Calculate and back to True afterwards. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel E-2007 starts, but Installer also starts 3 times??? | Setting up and Configuration of Excel | |||
| calculate from time started and finished to get total time used | Excel Worksheet Functions | |||
| Please Help: Macro Nearly Finished | Excel Discussion (Misc queries) | |||
| Turn off calculate event | Excel Discussion (Misc queries) | |||
| SheetChange event starts before .calculate finished | Excel Programming | |||
Hybrid Mode
