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?
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.
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.