APPLY.NAMES

Macro Sheets Only

Equivalent to choosing the Apply command from the Name submenu on the Insert menu. Replaces definitions with their respective names. If no names are defined in the current selection, APPLY.NAMES returns the #VALUE! error value. Use APPLY.NAMES to replace references and values in formulas with names.

Syntax

APPLY.NAMES(name_array, ignore, use_rowcol, omit_col, omit_row, order_num, append_last)
APPLY.NAMES?(name_array, ignore, use_rowcol, omit_col, omit_row, order_num, append_last)

Name_array is the name or names to apply as text elements in an array.

• To give more than one name as the argument, you must use an array. For example:
• APPLY.NAMES({"DataRange", "CriteriaRange"})
• If the names indicated by the argument name_array have already replaced all of the appropriate references or values, the #VALUE! error value is returned.

The next four arguments correspond to check boxes and options in the Apply Names dialog box. Arguments that correspond to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box.

Ignore corresponds to the Ignore Relative/Absolute check box.

Use_rowcol corresponds to the Use Row And Column Names check box. If use_rowcol is FALSE, the next three arguments are ignored.

Omit_col corresponds to the Omit Column Name If Same Column check box.

Omit_row corresponds to the Omit Row Name If Same Row check box.

Order_num determines which range name is listed first when a cell reference is replaced by a row-oriented and a column-oriented range name, as shown in the following table.

Order_num Order of range names

1 Row Column

2 Column Row

Append_last determines whether the names most recently defined are also replaced.

• If append_last is TRUE, Microsoft Excel replaces the definitions of the names in name_array and also replaces the definitions of the last names defined.
• If append_last is FALSE or omitted, Microsoft Excel replaces the definitions of the names in name_array only.

Related Functions

CREATE.NAMES Creates names automatically from text labels on a sheet

DEFINE.NAME Defines a name on the active sheet or macro sheet

LIST.NAMES Lists names and their associated information

List of Command-Equivalent Functions