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 CreateRange(Area[] rangeAreas)
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public Function CreateRange(ByVal rangeAreas As Area()) As Range
{signature}
{parameters}
{param:rangeAreas}Array or Areas representing the range.{param}
{returns}A {{Range}} object representing the range of cells created.{returns}
{example}{code:csharp|title=C#}

Parameters

Param

	rangeAreas
	rangeAreas

Array or Areas representing the range.

Returns
A `Range` object representing the range of cells created.

Example

Code Block

	csharp
	csharp
title	C#



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

{code} {code:

Code Block

	vb.net

|title=


	vb.net
title	vb.net

}



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

{code} {example}

Space Shortcuts

Page tree

Versions Compared

Old Version 6

New Version 7

Key