_Worksheet.Calculate Method
Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub Calculate
'Usage
Dim instance As _Worksheet
instance.Calculate()
void Calculate()
Remarks
To calculate |
Follow this example |
|---|---|
All open workbooks |
Application.Calculate |
A specific worksheet |
Worksheets(1).Calculate |
A specified range |
Worksheets(1).Rows(2).Calculate |