Workbook.CreateNamedRange(Area(), String)

Description

Creates a Range of cells from an array of Areas. A Range is a collection of Area s; an Area area is a rectangular collection of cells.

Parameters

rangeAreas

Array or Areas representing the range.

rangeName

The name to assign to the range.

Returns

A Range object representing the range of cells created.

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.

Examples