Share via

Calculation Property

  • Article

XlCalculation

XlCalculation can be one of these XlCalculation constants.
xlCalculationAutomatic Formulas are calculated automatically when precedent cells are changed.
xlCalculationManual Formulas are not recalculated until the user initiates a recalculation.

expression.Calculation

*expression   * Required. An expression that returns a Spreadsheet object.

Example

This example places Spreadsheet1 into manual calculation mode.

Sub ManualCalculationMode()

   Dim ssConstants

   Set ssConstants = Spreadsheet1.Constants

   ' Set Spreadsheet1 to manual calculation mode.
   Spreadsheet1.Calculation = ssConstants.xlCalculationManual

End Sub

Applies to | Spreadsheet Object

See Also | Calculate Method | CalculateFull Method