Hi Osiso
Below is some code which prints all the month form 1997 to 2009 in
199701,199702 format with a single loop.
To test it just paste it in a module.
If it will not help you then please clearly mention your problem.
Sub month_list()
year_start = 1997
year_end = 2009
months = 199700
i = 1
You say that you "have this list".
then: "I have a macro that reads a column and runs these values".
Then: you have to "manually enter in the next 5 months"..
the confusing part here is trying to figure out
where all this information is, where it's coming from and what's happening!
i really ca