Applies To
Application Object, Range Object, Worksheet Object.
Description
Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells in a sheet, as shown in the following table.
|
To calculate |
Example |
|
All open workbooks |
Application.Calculate (or just Calculate) |
|
A specific worksheet |
Worksheets(1).Calculate |
|
A specified range |
Worksheets(1).Rows(2).Calculate |
Syntax
object.Calculate
object
Optional for Application, required for Worksheet and Range. Specifies where the calculation will occur.
Example
This example calculates the formulas in columns A, B, and C in the used range on Sheet1.
Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate