Naming a Cell

D

David Biddulph

The short answer is RTFM.
The slightly longer answer is please type the word "name" into Excel help,
and see what that tells you.
 
D

Don Guillett

seletct the cell and type in a name in the name box

or
sub namecell()
range("a2").name="name"
end sub
 
F

FSt1

hi
2003
select the cell, on the toolbar>insert>name>define
2007
on the formula tab, in the defined name group, click name manager.

Regards
FSt1
 
E

Elkar

The simple way:

Select your cell, then type the name you want for it directly into the Name
Box.

The longer way:

In Excel 2003:
Go to INSERT Menu
Select "Name" then "Define..."
Type in a Name
Type in or choose a cell reference
Click "Add" button

In Excel 2007:
Go to the FORMULAS Tab
Click on "Name Manager" button
Click "New" button
Type in a Name
Type in or choose a cell reference
Click OK

HTH
Elkar
 
R

Rick Rothstein

If you go with the "select the cell and type in a name in the Name Box"
solution, just remember that you must press the Enter key after typing the
name to lock it in (don't just click out of the Name Box)
 
Top