Page History

{description}
{excerpt}Creates a range from a specified formula. A range is a collection of areas; an area is a rectangular collection of cells. This method can be used to create a non-rectangular range containing multiple rectangular areas.{excerpt}
{signature:C#}
 public Range CreateRange(System.String rangeFormula)
{signature}{signature:vb.net}
Public Function CreateRange(ByVal rangeFormula As String) As Range
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example "=A1:G10". The formula must be two\-dimensional, and can include cell references, and operators joining those references \(range ':', intersection ' ', and union ','\). Functions that return ranges cannot be used.{param}
{returns}A [Range|Range] object.{returns}
{example}{code:csharp|title=C#}

          Range rng = ws.CreateRange("=$B$12:$H$21 $F$18:$K$29");
        {code}
{code:vb.net|title=vb.net}

          Dim rng As Range = ws.CreateRange("=$B$12:$H$21 $F$18:$K$29")
        {code}

{example}