CircularReference Property

Applies To

Worksheet Object.

Description

Accessor. Returns a Range object that represents the range containing the first circular reference on the sheet, or Nothing if there is no circular reference present. The circular reference must be removed before calculation can proceed. Read-only.

Example

This example selects the first cell in the first circular reference on Sheet1.


Worksheets("Sheet1").CircularReference.Select