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

Workbook.CreateNamedRange(String, String)

Des= cription

=20

Creates a named Range of cells from = a specified formula. A Range is a collection of Area s; an Area area is a rectangular col= lection of cells.

=20
C#
=20
 public Range CreateNamedRange(System.String rangeFormula, System.String ra=
ngeName)
=20
=20
vb.net
=20
Public Function CreateNamedRange(ByVal rangeFormula As String, ByVal rangeN=
ame As String) As Range
=20
=20

Parameters=20

rangeFormu= la
Formula representing the range, for example "=3DSheet1!A1:G10&= quot;. The formula must be three-dimensional (specify a sheet), and can inc= lude only sheet and cell references, and operators joining those references= (range ':', intersection ' ', and union ','). Functions that return ranges= cannot be used.=20
rangeName The name to assign to the range.=20

Returns

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

Remarks

No= te that if a range named=20 rangeName already exists in the workbook, it will be overwritt= en with the new named range created by this method.=20

Examples

= =20
C#
=20
Range rng =3D wb.CreateNamedRange("=3DSheet1!A1:G10", "Range=
1");
=20
=20
vb.net
=20
Dim rng As Range =3D wb.CreateNamedRange("=3DSheet1!A1:G10", &quo=
t;Range1")
=20
------=_Part_7872_771510307.1711624627674--