<<Normally, Excel waits until all macros have ended before calling the
recalculation engine.
Experiment results: No longer true, in Excel 2000. Setting
Application.Calculation = xlCalculationManual stops calculation, but it
automatically resumes as soon as Application.Calculation =
xlCalculationAutomatic is executed.
Excel Recalculation articles:
"Excel Recalculation"
http://msdn2.microsoft.com/en-us/library/bb687891.aspx
"Recalculation in Microsoft Excel 2002"
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
--
Regards,
Bill Renaud