G Guest Nov 12, 2007 #1 I would like to assign a name to a cell according to its contents. Is this possible? And what is the syntax?
I would like to assign a name to a cell according to its contents. Is this possible? And what is the syntax?
B Bob Phillips Nov 12, 2007 #3 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)
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)
