Search notes:

Excel: Formulas -> Defined Names -> Name Manager

The Name Manager is used to create, edit and delete names that refer to ranges or array constants.
After defining such names, these names can be used in formulas and especially in worksheet functions as substitutes for the range (reference) or values in the array they were defined for. This allows to create cleaner and more comprehensible formulas.
The name manager also allows to to find already defined names.
The Name Manager can be opened with the keyboard shortcut ctrl+F3.

VBA Examples

Some Visual Basic for Application examples that demonstrate the usage of names include

Index