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

"kh" wrote in message
...
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

Many thanks



"Charles Williams" wrote:

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

"kh" wrote in message
...
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