$$Excel-Macros$$ Re: need a good method to count next 5 months

2009-08-20 Thread Sandeep
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

$$Excel-Macros$$ Re: need a good method to count next 5 months

2009-08-20 Thread Paul Schreiner
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