Page tree

Versions Compared

Key

  • 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
{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
{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}