共用方式為

Worksheet.CircularReference Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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.

public:
 property Microsoft::Office::Interop::Excel::Range ^ CircularReference { Microsoft::Office::Interop::Excel::Range ^ get(); };
public Microsoft.Office.Interop.Excel.Range CircularReference { get; }
member this.CircularReference : Microsoft.Office.Interop.Excel.Range
Public ReadOnly Property CircularReference As Range

Property Value

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.

Remarks

The circular reference must be removed before calculation can proceed.

Applies to