Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Application.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.

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
Show:
© 2015 Microsoft