View Source

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.

 public Range CreateRange(Area[] rangeAreas)

Public Function CreateRange(ByVal rangeAreas As Area()) As Range

Array or Areas representing the range.

A Range object representing the range of cells created.


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


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