Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)

Description

Creates a named range, containing one area. A range is a collection of areas; an area is a rectangular collection of cells.

Parameters

firstRow

0-based first row of the range.

firstColumn

0-based first column column of the range.

numRows

Number of rows in the area. Maximum: The row limit of the file format you are using.

numColumns

Number of columns in the range. Maximum: The column limit of the file fortmat you are using.

rangeName

The name of the new range.

Returns

A Range object.

Remarks

Note that if a range named rangeName already exists in the worksheet, it will be overwritten with the new named range created by this method.

Examples