Excel cell naming shortcut

[DnetMHZ]

ok, here is my situation.

I have a column of cells that I want to add cell names to.
I have another column with the names I want to add

For example column A contains the cells I want to name
And column B comtains the names


..A...........B
cell1.....name1
cell2.....name2
...
..
.


I need a way to have this done quickly for a few hundred cells.

Any ideas?

vba maybe?

 

[SeTeS]

You'll need to do this in VB. I'd suggest checking the forum at www.mrexcel.com.

 

[petesamprs]

If you have a basic understanding of excel, you can just start recording a macro, do what you to do on 1 or 2 rows, stop recording, then edit the code created by the macro so that it does it for all rows.

Alt+F11 gets you to the VBA underlying code. Look in Module 1. Use the help feature to edit the code to accomplish what you want.

 

[DnetMHZ]

Originally posted by: SeTeS
You'll need to do this in VB. I'd suggest checking the forum at www.mrexcel.com.

Thanks SeTeS, the guys over at mrexcel answered my question in minutes!