Page History

{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:vb.net}
Public Function CreateNamedRange(ByVal rangeAreas As Area(), ByVal rangeName As String) As Range
{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}
{code: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")
        {code}

{example}