CREATE.NAMES macro

Equivalent to clicking the Create command on the Name submenu of the Insert menu. Use CREATE.NAMES to quickly create names from text labels on a sheet.

Arguments are logical values corresponding to check boxes in the Create Names dialog box. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE or omitted, Microsoft Excel clears the check box.

Syntax

CREATE.NAMES(top, left, bottom, right)

CREATE.NAMES?(top, left, bottom, right)

Top    corresponds to the Top Row check box.

Left    corresponds to the Left Column check box.

Bottom    corresponds to the Bottom Row check box.

Right    corresponds to the Right Column check box.

Remarks

The cell containing the label text that Microsoft Excel uses to create the names is not included in the resulting named range.

Related Functions

APPLY.NAMES   Replaces references and values with their corresponding names

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

DELETE.NAME   Deletes a name

FORMULA.GOTO   Selects a named area or reference on any open workbook

Return to index