Message-ID: <1599137713.7867.1711624506341.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7866_136301345.1711624506341" ------=_Part_7866_136301345.1711624506341 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Workbook.CreateRange(String)

Workbook.CreateRange(String)

Description=20

Creates a Range of cells from a spec= ified formula. A Range is a collection of Area s; an Area area is a rectangular collectio= n of cells.

=20
C#
=20
 public Range CreateRange(System.String rangeFormula)
=20
=20
vb.net
=20
Public Function CreateRange(ByVal rangeFormula As String) As Range
=20
=20

Parameters

=20
rangeFormula
Form= ula representing the range, for example "=3DSheet1!A1:G10". The f= ormula must be three-dimensional (specify a sheet), and can include only sh= eet and cell references, and operators joining those references (range ':',= intersection ' ', and union ','). Functions that return ranges cannot be u= sed.=20

Returns

A=20 Range object representing the range of cells created.=20

Examples

=20
C#
=20
Range rng =3D wb.CreateRange("=3DSheet1!A1:G10");
=20
=20
vb.net
=20
Dim rng As Range =3D wb.CreateRange("=3DSheet1!A1:G10")
=20
------=_Part_7866_136301345.1711624506341--