Page History

Description

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#

 public Range CreateNamedRange(Area[] rangeAreas, System.String rangeName)

Signature

	vb.net
	vb.net

Public Function CreateNamedRange(ByVal rangeAreas As Area(), ByVal rangeName As String) As Range

Parameters

Param

	rangeAreas
	rangeAreas

Array or Areas representing the range.

Param

	rangeName
	rangeName

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#


          Range rng = wb.CreateNamedRange(
               new Area[]{
               worksheet1.CreateArea(2, 4, 2, 5),
               worksheet2.CreateArea(2, 4, 2, 5)},
               "MyRange");

Code Block

	vb.net
	vb.net
title	vb.net


          Dim rng As Range = wb.CreateNamedRange( _
               New Area(){ _
               worksheet1.CreateArea(2, 4, 2, 5), _
               worksheet2.CreateArea(2, 4, 2, 5)}, _
               "MyRange")

Space Shortcuts

Page tree

Versions Compared

Old Version 7

New Version Current

Key