Referring to changing column headers

EdwardP

New Member
Joined
Feb 2, 2005
Messages
1
Hi All,

New to the board and new to Excel VBA. We are currently using Excel 2002 and have the following situation.

We've got a spreadsheet that has several column headers along row 1. It is entirely possible that the location of the headers may move, so therefore we would like to refer to the cells in the column by a name. For example, we have the following column headers in Row1:

TestCase RequirementID Description Dependency

I've toyed with using the "name" feature where I create a name for each cell. But am having difficulty implementing it in VBA.

I would like to refer to something in the following manner:

"Dependency" Column:Row3 as opposed to "D4".

Any help would be greatly appreciated. Thanks in advance.

-Ed
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi, welcome to the board!

Just a thought, but what about assigning a name to the whole column.
For example, assign the name Dependency to all of Column D.

Then in VBA, refer to it something like this:

Code:
Sub test1()
MsgBox Range("Dependency").Rows(3)
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,284
Members
414,051
Latest member
tabecker

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