Search : in
By :

Excel Named Range to single cell

Last answer on Sep 27, 2008 3:19:19 pm BST Hitman11, on Jul 21, 2008 3:28:49 pm BST 
 Report this message to moderators

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.

Best answers for « Excel Named Range to single cell » in :
Excel macro help needed to name ranges Show
Using Named Ranges to create dymaic graphs Show
[VBA] Deleting a word in a range of cell Show [VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Excel – Total Range of Values ShowExcel – Total Range of Values Issue Solution Note Issue I'm trying to get a range of values totalled. I have one set of columns, let’s say column A1 to A200, ranging from -30 up to 1000 and another column adjacent (let’s say B1 to...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

 Tilemachos, on Sep 27, 2008 3:19:19 pm BST
  • +4

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.

   
Reply to Tilemachos
Ask your question Reply
They need your help