Names.Add Method (Excel)

Defines a new name for a range of cells.

expression .Add(Name, RefersTo, Visible, MacroType, ShortcutKey, Category, NameLocal, RefersToLocal, CategoryLocal, RefersToR1C1, RefersToR1C1Local)

expression A variable that represents a Names object.

Parameters

Name

Required/Optional

Data Type

Description

Name

Optional

Variant

Specifies the text, in English, to use as the name if the NameLocal parameter is not specified. Names cannot include spaces and cannot be formatted as cell references.

RefersTo

Optional

Variant

Describes what the name refers to, in English, using A1-style notation, if the RefersToLocal, RefersToR1C1, and RefersToR1C1Local parameters are not specified.

Note Note

Nothing is returned if the reference does not exist.

Visible

Optional

Variant

True specifies that the name is defined as visible. False specifies that the name is defined as hidden. A hidden name does not appear in the Define Name, Paste Name, or Goto dialog box. The default value is True.

MacroType

Optional

Variant

The macro type, determined by one of the following values:

  • 1 - User-defined function (Function procedure)

  • 2 - Macro (Sub procedure)

  • 3 or omitted - None (the name does not refer to a user-defined function or macro)

ShortcutKey

Optional

Variant

Specifies the macro shortcut key. Must be a single letter, such as "z" or "Z". Applies only for command macros.

Category

Optional

Variant

The category of the macro or function if the MacroType argument equals 1 or 2. The category is used in the Function Wizard. Existing categories can be referred to either by number, starting at 1, or by name, in English. Microsoft Office Excel 2007 creates a new category if the specified category does not exist.

NameLocal

Optional

Variant

Specifies the localized text to use as the name if the Name parameter is not specified. Names cannot include spaces and cannot be formatted as cell references.

RefersToLocal

Optional

Variant

Describes what the name refers to, in localized text using A1-style notation, if the RefersTo, RefersToR1C1, and RefersToR1C1Local parameters are not specified.

CategoryLocal

Optional

Variant

Specifies the localized text that identifies the category of a custom function if the Category parameter is not specified.

RefersToR1C1

Optional

Variant

Describes what the name refers to, in English using R1C1-style notation, if the RefersTo, RefersToLocal, and RefersToR1C1Local parameters are not specified.

RefersToR1C1Local

Optional

Variant

Describes what the name refers to, in localized text using R1C1-style notation, if the RefersTo, RefersToLocal, and RefersToR1C1 parameters are not specified.

Return Value

A Name object that represents the new name.

This example defines a new name for the range A1:D3 on Sheet1 in the active workbook.

Note Note

Nothing is returned if Sheet1 does not exist.

Sub MakeRange() 
 
    ActiveWorkbook.Names.Add _ 
        Name:="tempRange", _ 
        RefersTo:="=Sheet1!$A$1:$D$3" 
 
End Sub

Concepts

Other resources

Show:
© 2014 Microsoft