Naming a cell according to its contents

G

Guest

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
creat sheets with assigned name and protected 4
Change column width according to specific cell content 2
Creating a new worksheet and naming it according to a specific cel 1
Read contents of #Name cell 3
Rename Worksheet Based on Cell value 0
Formula to manipulate cell font 5
Macro to complete Google search based on a cell? 0

Top