We recommend using Visual Studio 2017
This documentation is archived and is not being maintained.

NamedRange.Column Property

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

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

int Column { get; }

Property Value

Type: System.Int32
The number of the first column in the first area of the NamedRange control. Column A returns 1, column B returns 2, and so on.

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: