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