Page History

{description}
{excerpt}Creates a named range, containing one area. A range is a collection of areas; an area is a rectangular collection of cells.{excerpt}
{signature:C#}
 public Range CreateNamedRange(int firstRow, int firstColumn, int numRows, int numColumns, System.String rangeName)

{signature}{signature:vb.net

}
Public Function CreateNamedRange(ByVal firstRow As Integer, ByVal firstColumn As Integer, ByVal numRows As Integer, ByVal numColumns As Integer, ByVal rangeName As String) As Range

...

0-based first row of the range.

...

0-based first column column of the range.

...

Number of rows in the area. Maximum: The row limit of the file format you are using.

...

Number of columns in the range. Maximum: The column limit of the file fortmat you are using.

...

The name of the new range.

{signature}
{parameters}
{param:firstRow}0\-based first row of the range.{param}
{param:firstColumn}0\-based first column column of the range.{param}
{param:numRows}Number of rows in the area. Maximum: The row limit of the file format you are using.{param}
{param:numColumns}Number of columns in the range. Maximum: The column limit of the file fortmat you are using.{param}
{param:rangeName}The name of the new range.{param}
{returns}A [Range|Range] object.{returns}
{remarks}
Note that if a range named {{rangeName}} already exists in the worksheet, it will be overwritten with the new named range created by this method.
{remarks}
{example}{code:csharp|title=C#}
Range rng = ws.CreateNamedRange(4, 4, 15, 6, "Range1");

{code}
{code:vb.net

|title=vb.net

}
Dim rng As Range = ws.CreateNamedRange(4, 4, 15, 6, "Range1"){code}

{example}