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)"
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,085
Messages
5,857,273
Members
431,867
Latest member
Dalorian

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