Excerpt |
---|
Creates a Range of cells from an array of Areas. A Range is a collection of Area s; an Area area is a rectangular collection of cells. |
Signature |
---|
C# | C# | Wiki Markup |
---|
{description}
{excerpt}Creates a [Range|Range] of cells from an array of Areas. A {{Range}} is a collection of [Area|Area] s; an {{Area}} area is a rectangular collection of cells.{excerpt}
{signature:C#}
public Range CreateNamedRange(Area[] rangeAreas, System.String rangeName)
|
Signature |
---|
{signature}{signature:vb.net | vb.net | }
Public Function CreateNamedRange(ByVal rangeAreas As Area(), ByVal rangeName As String) As Range
|
...
Array or Areas representing the range.
...
The name to assign to the range.
Returns |
---|
A Range object representing the range of cells created. |
Remarks |
---|
Note that if a range named rangeName already exists in the workbook, it will be overwritten with the new named range created by this method. |
Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{signature}
{parameters}
{param:rangeAreas}Array or Areas representing the range.{param}
{param:rangeName}The name to assign to the range.{param}
{returns}A {{Range}} object representing the range of cells created.{returns}
{remarks}
Note that if a range named {{rangeName}} already exists in the workbook, it will be overwritten with the new named range created by this method.
{remarks}
{example}{code:csharp|title=C#}
Range rng = wb.CreateNamedRange(
new Area[]{
worksheet1.CreateArea(2, 4, 2, 5),
worksheet2.CreateArea(2, 4, 2, 5)},
"MyRange");
Code Block |
---|
{code}
{code:vb.net
vb.net | title | |title=vb.net
}
Dim rng As Range = wb.CreateNamedRange( _
New Area(){ _
worksheet1.CreateArea(2, 4, 2, 5), _
worksheet2.CreateArea(2, 4, 2, 5)}, _
"MyRange")
{code}
{example}