| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a cell according to its contents
I would like to assign a name to a cell according to its contents. Is this
possible? And what is the syntax? -- Thanks very much. KDJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Naming a cell according to its contents
Example(s)
-- Don Guillett Microsoft MVP Excel SalesAid Software "KDJ" wrote in message ... I would like to assign a name to a cell according to its contents. Is this possible? And what is the syntax? -- Thanks very much. KDJ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Naming a cell according to its contents
Syntax would be the same as naming it after anything else.
Range("A1").Name = Range("A1").Value but you have to be careful you don't put any spurious characters in there. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "KDJ" wrote in message ... I would like to assign a name to a cell according to its contents. Is this possible? And what is the syntax? -- Thanks very much. KDJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Table of Contents based on Heading style - not naming a ran | Excel Discussion (Misc queries) | |||
| concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
| Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Copying cell contents to add to existing contents in another cell | Excel Programming | |||
Hybrid Mode
