NamedRange.DirectDependents Property
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a Range that represents the range containing all the direct dependents of the NamedRange control.
public:
property Microsoft::Office::Interop::Excel::Range ^ DirectDependents { Microsoft::Office::Interop::Excel::Range ^ get(); };
public Microsoft.Office.Interop.Excel.Range DirectDependents { get; }
member this.DirectDependents : Microsoft.Office.Interop.Excel.Range
Public ReadOnly Property DirectDependents As Range
A Range that represents the range containing all the direct dependents of the NamedRange control.
The following code example creates a NamedRange and sets a reference in cell C1 to refer to the NamedRange. It then sets a reference in cell C2 to refer to cell C1. The code example then uses the DirectDependents property to select the direct dependent of the NamedRange, which is cell C1.
This example is for a document-level customization.
Microsoft.Office.Tools.Excel.NamedRange directDependentsRange;
private void SelectDirectDependents()
{
directDependentsRange = this.Controls.AddNamedRange(
this.Range["B1"], "createMonthRange");
this.directDependentsRange.Value2 = "Smith";
this.Range["C1"].Value2 = "=" +
this.directDependentsRange.Address[false, true,
Excel.XlReferenceStyle.xlA1, false];
this.Range["C2"].Value2 = "=C1";
this.directDependentsRange.DirectDependents.Select();
}
Private directDependentsRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub SelectDirectDependents()
directDependentsRange = Me.Controls.AddNamedRange( _
Me.Range("B1"), "createMonthRange")
Me.directDependentsRange.Value2 = "Smith"
Me.Range("C1").Value2 = "=" & _
Me.directDependentsRange.Address(False, True, _
Excel.XlReferenceStyle.xlA1, False, )
Me.Range("C2").Value2 = "=C1"
Me.directDependentsRange.DirectDependents.Select()
End Sub
This property only works on the active sheet and cannot trace remote references.
Product | Versions |
---|---|
Visual Studio Tools for Office | 2017, 2019, 2022 |