Export (0) Print
Expand All
Expand Minimize

Worksheet.CircularReference Property

Gets a Range object that represents the range containing the first circular reference on the sheet, or gets null if there is no circular reference on the sheet.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Range CircularReference { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range
A Range object that represents the range containing the first circular reference on the sheet; null if there is no circular reference on the sheet.

The circular reference must be removed before calculation can proceed.

Show:
© 2014 Microsoft