Naming cells of a column with VBA?

[joelpe]

Hi all,

I need to name all the cells of a column ("A" column) of a sheet with the cell value. I mean, if the cell says "Mister", the name would be "Mister" as well.

I know to do it manually, but I think that a macro for this will be very helpful and not too hard to make, but I don´t know how to write it.

Any suggestions?


Many thanks

 

[RoryA]

Some cells has characters like "&", but it shouldnt be a problem with the naming right?

Wrong. You can't name a cell with a name that contains an ampersand. You're basically limited to letters, numbers, underscores and full stops. See Debra's page here: https://www.contextures.com/xlNames01.html#rules

 

[joelpe]

I thought the Excel replaced the "&" character with an underscore automatically while doing the name (actually if you do it manually it does). So I imagine that was the error.

Anyway I manage to do it without a macro,I just had to copy the column, and then in Formulas->Create from selection


However,thanks for the help!