Calculate Method

Calculates the open workbook, a specific worksheet in a workbook, or a specified range of cells on a worksheet.

expression.Calculate

*expression   * An expression that returns a Range, Spreadsheet, or Worksheet object.

Example

This example causes the active worksheet on the spreadsheet to be recalculated.

Spreadsheet1.ActiveSheet.Calculate

This example causes the range A1:G5 in Sheet1 to be recalculated.

Spreadsheet1.Worksheets("Sheet1").Range("A1:G5").Calculate

Applies to | Range Object | Spreadsheet Object | Worksheet Object

See Also | CalculateFull Method | Calculation Property