Excel VBA Loop to create column header variables

[hellfire45]

Hi guys,

Has anybody ever written a loop that will make an INTEGER variable out of each column header in a worksheet? If so, could you please share the method?

thank you!

 

[Norie]

You can't create variables 'on the fly' like that in VBA, what are you actually trying to do?

 

[Nanette]

HI guys,

I am having the same issue, so please forgive me for rail-roading the thread. My requirement is to create a macro to historically list and group data by year for a variable number of years. The number of years is not known and may expand or shrink as required. Currently, if there are 4 years of data - the headings will be FY18, FY17, FY16, FY15, and the data belonging to each of these years will be listed below. However, next year, the same data will be required along with the new FY, so the headings will be FY19, FY18, FY17, FY16, FY15, and so on for up to 20 years or 25, for corporate modelling.

I was wondering if "Dim FY_nn As String" can be contained within a loop, where the nn is replaced by a number for the number of each year required.

Any suggestions will be so welcome, as I am completely at a loss how I can achieve this

Nanette