How to name a cell

[pinehead]

how do you name a cell, not lable it but name it?

[davesexcel]

how do you name a cell, not lable it but name it?

select your cell or range
click on the arrow that is to the left of the formula box
when the box is highlited type in a one word name and then press enter
When you want to refer to that named cell any where in the workbook all you have to do is refer to it ex: =namedcell, you can use it in data validations, and in vba codes
this site explains names a lot better than I can
http://www.xldynamic.com/source/xld.Names.html

[Tom Ogilvy]

in code

activecell.name = "pinehead"

--
Regards,
Tom Ogilvy


"pinehead" <[email protected]> wrote in
message news:[email protected]...
>
> how do you name a cell, not lable it but name it?
>
>
> --
> pinehead
> ------------------------------------------------------------------------
> pinehead's Profile:
http://www.excelforum.com/member.php...o&userid=31721
> View this thread: http://www.excelforum.com/showthread...hreadid=516738
>