Can this be done

Svgmassive

Board Regular
Joined
Nov 2, 2010
Messages
113
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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
If I understand what you want, use an enumeration:
Code:
Enum myCol
    T_Col = 1
    pay_col
    Bob_col
    Joe_Col
End Enum
 
Sub x()
    MsgBox Rows(1).Cells(pay_col).Address
End Sub
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

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
Back
Top