| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Application.Calculate method (Excel) |
vbaxl10.chm183084 |
|
|
2818a08b-1c02-9f10-db03-db509a251f60 |
04/04/2019 |
medium |
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.
| 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 |
This example calculates the formulas in columns A, B, and C in the used range on Sheet1.
Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate[!includeSupport and feedback]