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

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

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