I need to fill a column with dates using a VBA. I need a VBA because this will be part of a larger script.
Assume you know two variables. The first determining the beginning month and the second determining the ending month.
BeginningMonth = 5
EndingMonth = 7
Now I want to fill a column, lets say column A starting from row 1. I want to fill from the first day in May until the last day in July.
How can I do that?