Ok, So I have a worksheet where the user inputs a start date in cell a2 and an end date in cell b2
I need to work out the months this covers. So for example 01/01/2010 - 31/12/2010 and then put a column heading in for each month starting in B4 and going across that row for however many columns i need.
So in this case I would have Jan-2010 in B4, Feb-2010 in C4 and so on up until Dec 2010 in the last column.
Can anyone give me pointers on how to do this in VBA. I also need to be able to use the calculated months in sql queries so it would be good if I could have another row below the headings with the date range in date format So b4 would be Jan-2010. b5 would be 01/01/2010 - 31/01/2010.
Any help would be greatly appreciated