Calculate Method

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

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