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.
Syntax
expression.Calculate
expression A variable that represents a Worksheet object.
Remarks
| To calculate | Follow this example |
|---|---|
| All open workbooks | Application.Calculate (or just Calculate)
|
| A specific worksheet | Worksheets(1).Calculate
|
| A specified range | Worksheets(1).Rows(2).Calculate |
Example
This example calculates the formulas in columns A, B, and C in the used range on Sheet1.
| Visual Basic for Applications |
|---|
|