APPLY.NAMES macro

Equivalent to clicking the Apply command on 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.

 

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.

 

Related Functions

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

DEFINE.NAME   Defines a name in the active workbook

LIST.NAMES   Lists names and their associated information

Return to index