Referring to changing column headers

[EdwardP]

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

 

[Scott Huish]

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:

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