Calculate Method

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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