Excel Named Range to single cell

Closed
Hitman11 - Jul 21, 2008 at 10:28 AM
 Tilemachos - Sep 27, 2008 at 10:19 AM
Hello Everybody,

I want to name range single cell by the value of the active cell, may i know how to do it???

For example,
in cell A1 I've value "XXXX_07", and i want the cell A1 named as XXXX_07
in cell B1 I've value "XXXX_08", and i want the cell B1 named as XXXX_08

If I've hundreds of single cell with those value, what is the fastest way to get the name range done???

Thanks for the help.
Related:

1 response

Hi Hitman11,

I suggest you to redefine your question, because it appears that you are asking for
two (2) different things, assumming that you are requesting one (1) answer!

Yours,
Tilemachos.
4