Can this be done

[Svgmassive]

I have an array that populate the rows(headers) with names (15). i have variables declare as long that i am trying to get the column number assigned to.
T_col as long
Pay_col as long etc.

can i put the t_col and pay_col etc. into an array that i call populate with the column number as i loop through the headers.
thanks

 

[shg]

If I understand what you want, use an enumeration:

Enum myCol
    T_Col = 1
    pay_col
    Bob_col
    Joe_Col
End Enum
 
Sub x()
    MsgBox Rows(1).Cells(pay_col).Address
End Sub

 

[Svgmassive]

shg4421

That's ok setting them like that but if the user insert a column then the function would not be right.

 

[shg]

That's true; its applicable to situations where the columns are stable.

You could instead name each cell in the header. the name would follow the cell through column insertions.