Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

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.

Signature
C#
C#
 public Range CreateRange(System.String rangeFormula)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateRange(ByVal rangeFormula As String) As Range
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example 
Parameters
Param
rangeFormula
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#}

Returns

A Range object.

Example
Code Block
csharp
csharp
titleC#


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


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