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.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

 

Show:
© 2015 Microsoft