Worksheet.Calculate Method (Excel)
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.
Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate