Naming Ranges by Row and Column headers

jroo

Board Regular
Joined
May 22, 2003
Messages
157
I want to name cells within a table by its row and column heading

For instance if row headings are months(Jan, Feb, Mar...) and column headings are years (2001, 2002, 2003...)...i want each cell within this table to be named

Jan2001
Feb2001
Mar2001...

any ideas on how i can do this...is there on option in "insert - name (define/create)"
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"I want to name cells within a table by its row and column heading"

1) why, and
2) have you investgated the "accept labels in formulas" option (tools | options | calculation)
3) review the help file for "About labels and names in formulas"
 

CraigM

Active Member
Joined
Feb 27, 2003
Messages
320
Here's a bit of code if you want to anyway:

ColHeadRow = 1 'Row that contains the column headers
RowHeadCol = 1 'Column that contains the row headers
Set Rng = Sheet1.Range("A2:G13") 'Range that you want to name

For Each c In Rng
c.Name = Cells(c.Row, RowHeadCol) & Cells(ColHeadRow, c.Column)
Next
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,480
Members
414,143
Latest member
lonnie451

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top