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.
| 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 |
Syntax
expression.Calculate
expression Optional for Application, required for Worksheet and Range. An expression that returns an object in the Applies To list.