DefineName

12 Sep 20251 minute to read

Represents a defined name in the spreadsheet.
A defined name is a meaningful identifier that refers to a specific cell or range, and can be used in formulas.

Properties

comment string

Provides a comment or description for the defined name.

Defaults to ’’

name string

Specifies a unique name for the defined name, which can be used in formulas.

Defaults to ’’

refersTo string

Specifies the cell or range reference associated with the defined name.
The reference can be provided with or without the = prefix.

Defaults to ’’

scope string

Defines the scope of the name.
If not specified, the name is scoped to the entire workbook.
If a sheet name is provided, the name will be available only within that specific sheet.

Defaults to ’’