Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

NamedRange.Row Property

Gets the number of the first row of the first area in the NamedRange control.

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

int Row { get; }

Property Value

Type: System.Int32
The number of the first row of the first area in the NamedRange control.

The following code example creates a NamedRange and uses the Column and Row properties to display the numbers of the first column and row in the NamedRange.

This example is for a document-level customization.

Microsoft.Office.Tools.Excel.NamedRange columnAndRowRange;
private void DisplayColumnAndRow()
{
    columnAndRowRange = this.Controls.AddNamedRange(
        this.Range["A3", "D6"], "columnAndRowRange");
    MessageBox.Show("The first column in the range is column " +
        this.columnAndRowRange.Column.ToString() + 
        " and the first row is " +
        this.columnAndRowRange.Row.ToString());
}

Show:
© 2015 Microsoft