Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to name a cell
how do you name a cell, not lable it but name it -- pinehea ----------------------------------------------------------------------- pinehead's Profile: http://www.excelforum.com/member.php...fo&userid=3172 View this thread: http://www.excelforum.com/showthread.php?threadid=51673 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to name a cell
pinehead Wrote: 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 al you have to do is refer to it ex: =namedcell, you can use it in dat validations, and in vba codes this site explains names a lot better than I can http://www.xldynamic.com/source/xld.Names.htm -- davesexce ----------------------------------------------------------------------- davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170 View this thread: http://www.excelforum.com/showthread.php?threadid=51673 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to name a cell
in code
activecell.name = "pinehead" -- Regards, Tom Ogilvy "pinehead" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming |