Application.Calculate Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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: