Export (0) Print
Expand All

Range.Calculate Method

Office 2007
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 Range object.

Return Value
Variant

Remarks

To calculateFollow this example
All open workbooksApplication.Calculate (or just Calculate)
A specific worksheetWorksheets(1).Calculate
A specified rangeWorksheets(1).Rows(2).Calculate

Example

This example calculates the formulas in columns A, B, and C in the used range on Sheet1.

Visual Basic for Applications
Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate



Community Additions

ADD
Show:
© 2014 Microsoft