Excel.Range.Calculate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.Calculate method (Excel)	vbaxl10.chm144090	vbaxl10.chm144090	Excel.Range.Calculate	7c29afda-4980-6992-fc8d-b4caf2f74660	05/10/2019	medium

Range.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 table in the Remarks section.

Syntax

expression.Calculate

expression A variable that represents a Range object.

Return value

Variant

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

[!includeSupport and feedback]