Calculate Method

Calculate Method

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   An expression that returns a Range, Spreadsheet, or Worksheet object.


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


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



© 2016 Microsoft