Udostępnij za pośrednictwem


NamedRange.Top Property (2007 System)

Gets the distance, in points, from the top edge of row 1 (one) to the top edge of the NamedRange control.

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Top As Object
'Usage
Dim instance As NamedRange 
Dim value As Object 

value = instance.Top
[BrowsableAttribute(false)]
public Object Top { get; }
[BrowsableAttribute(false)]
public:
property Object^ Top {
    Object^ get ();
}
public function get Top () : Object

Property Value

Type: System.Object
The distance, in points, from the top edge of row 1 (one) to the top edge of the NamedRange control.

Remarks

If the NamedRange control is more than one row high, the top (lowest numbered) row in the NamedRange control is used.

Examples

The following code example creates a NamedRange control. It then uses the Left and Top properties to display the distance from the left edge of column A to the left edge of the NamedRange, and the distance from the top of row 1 to the top edge of the NamedRange.

This example is for a document-level customization.

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

Private Sub DisplayLeftAndTop()
    leftAndTopRange = Me.Controls.AddNamedRange( _
        Me.Range("B4", "D6"), "addIndentRange")
    leftAndTopRange.Select()
    MessageBox.Show("The left border of the NamedRange " & _
        "control is at " & Me.leftAndTopRange.Left & _
        " and the top is at " & Me.leftAndTopRange.Top & ".")
End Sub
Microsoft.Office.Tools.Excel.NamedRange leftAndTopRange;
private void DisplayLeftAndTop()
{
    leftAndTopRange = this.Controls.AddNamedRange(
        this.Range["B4", "D6"], "addIndentRange");
    leftAndTopRange.Select();
    MessageBox.Show("The left border of the NamedRange control "
        + "is at " + this.leftAndTopRange.Left + 
        " and the top is at " + this.leftAndTopRange.Top + ".");
}

.NET Framework Security

See Also

Reference

NamedRange Class

NamedRange Members

Microsoft.Office.Tools.Excel Namespace