Calculation mode and recalcs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. In VBA, if the current Application.Calculation mode is set to
xlCalculationManual, does setting it to xlCalculationAutomatic force a recalc
of any pending changes to the workbook or do I need to explicitly call
Application.Calculate() ?

Many thanks

kh
 
setting to Automatic will cause a Recalc if there are any volatile or
uncalculated cells.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
 
Back
Top