Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.



© 2015 Microsoft