Megosztás a következőn keresztül:


Worksheet.CircularReference Property

Gets a Range object that represents the range containing the first circular reference on the sheet, or gets nulla null reference (Nothing in Visual Basic) 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)

Syntax

'Declaration
ReadOnly Property CircularReference As Range
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; nulla null reference (Nothing in Visual Basic) if there is no circular reference on the sheet.

Remarks

The circular reference must be removed before calculation can proceed.

.NET Framework Security

See Also

Reference

Worksheet Interface

Microsoft.Office.Tools.Excel Namespace