NamedRange.Parent Property

Gets the parent object of the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property Parent As Object

Object Parent { get; }

Property Value

Type: System.Object
The parent object of the NamedRange control.

Examples

The following code example creates a NamedRange and then uses the Parent property to display the name of the parent Worksheet of the NamedRange.

This example is for a document-level customization.

Private parentNameRange As Microsoft.Office.Tools.Excel.NamedRange

Private Sub DisplayParentName()
    parentNameRange = Me.Controls.AddNamedRange( _
        Me.Range("B2"), "parentNameRange")
    parentNameRange.Select()
    Dim parentSheet As Excel.Worksheet = _
        CType(Me.parentNameRange.Parent, Excel.Worksheet)
    MessageBox.Show("The NamedRange is in worksheet: " & _
        parentSheet.Name)
End Sub

Microsoft.Office.Tools.Excel.NamedRange parentNameRange;
private void DisplayParentName()
{
    parentNameRange = this.Controls.AddNamedRange(
         this.Range["B2"], "parentNameRange");
    parentNameRange.Select();
    Excel.Worksheet parentSheet = 
        (Excel.Worksheet)this.parentNameRange.Parent;
    MessageBox.Show("The NamedRange is in worksheet: " + 
        parentSheet.Name);
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace