Search : in
By :

Excel macro help needed to name ranges

Last answer on Nov 17, 2008 2:53:35 am GMT Galah, on Aug 31, 2008 2:57:58 am BST 
 Report this message to moderators

Hello,

I have a 10 column x 500 row spreadsheet A1:J500

I would like to name ranges as follows:
Range A1:J1 should be named with the content of cell A1, range A2:J2 should be named with the content of cell A2, etc, etc.

Can anyone help me with a macro that will do this for the 500 rows, please?

I'm using Excel 2000 and 2003.

Many thanks in advance.

Galah

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « Excel macro help needed to name ranges » in :
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Download Excel Macro Processor Show
Download Unit Converter for Excel ShowIt is not always necessary to use an expensive or sophisticated program or to convert measurement units. It is sometimes enough to use Excel worksheet by only adding a plug-in. Unit Converter for Excel is one of Microsoft Excel plug-in which can...
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...
Ask your question Reply

1

trance3223, on Aug 31, 2008 3:06:24 pm BST
  • +1

Have you checked if there isnt any details in the help file of excel itself?

you can have something there

   
Reply to trance3223

2

Galah, on Sep 1, 2008 12:12:37 am BST

Hi Trance3223,

Thank you for your reply. The first place I looked was the Excel help file, but could not find an answer to my problem there. Or on any of the Microsoft websites.

Which is why I asked the experts here :-)

Cheers,
Galah

   
Reply to Galah

3

......, on Oct 14, 2008 3:19:31 pm BST

Range("A1:J1").Name = Range(A1").value - assuming it's a string value

that's it - so range A1:J1 will be named/labeled by the content in A1

   
Reply to ......

4

 dufus, on Oct 23, 2008 10:09:58 am BST

Highlight or select the range of cells. Ctrl+Shift+F3 Select the top, left, bottom, right most column, or row to use to Name your selected range. This does not work on one cell. You can however, right click from your active cell, select "Name a range", and type in the name. This works for a single or range of cells.

   
Reply to dufus
Ask your question Reply
They need your help