Calculate Method

Microsoft Office Web Components Visual Basic

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