Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{excerpt}Creates a named range, containing one area. A range is a collection of areas; an area is a rectangular collection of cells.{excerpt}
 public Range CreateNamedRange(int firstRow, int firstColumn, int numRows, int numColumns, System.String rangeName)
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
{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}
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.
Range rng = ws.CreateNamedRange(4, 4, 15, 6, "Range1");{code}
Dim rng As Range = ws.CreateNamedRange(4, 4, 15, 6, "Range1"){code}