View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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