Excel Developer Help

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.

expression.Calculate

expression A variable that represents an Application 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
`Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate`