Unanswered: Need to Populate Cells in a Row based on a Date Range
I am trying to allow the user to enter two dates (In a specific format ie 2009.JAN) and depending on the dates entered I need excel to enter that range in a row of cells in the specific format shown ealier.
For example, I enter in "Start Date" cell of 2009.JAN and the "End Date" cell of 2009.MAY. In a row excel would enter into individual cells:
2009.JAN 2009.FEB 2009.MAR 2009.APR 2009.MAY
The values entered in the Start and End date could range from 2004.SEP thru 2010.DEC and no matter how long the range is I need excel to populate in individual cells along a specific row.
Can anyone get me started with the VBA code that would be required for this? I would greatly appreciate it.