ExcelBanter - Calculation mode and recalcs

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calculation mode and recalcs (https://www.excelbanter.com/excel-programming/390617-calculation-mode-recalcs.html)

kh[_2_]

Calculation mode and recalcs

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

Charles Williams

Calculation mode and recalcs

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

kh[_2_]

Calculation mode and recalcs

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

All times are GMT +1. The time now is 05:19 PM.