This is an old thread from April 2013 and macro in now updated as it can not cope with a start date different from the 1st in a month.
Macro starts by checking if cell B2 (first date in the list) contains a date that corresponds to the first of the month. If not a row is inserted and formate from the inserted row is copied from the row below. Then EoMonth function is used to set the date for the 1st month. Then the last date in the B column is also set by using the same function if missing.
After that all dates between first and last date in that particular month are checked and if any is missing a new row is insert and the missing date added.
In the original thread from the OP there should also be a numerical value added in columns A, C, D, E and F but this part of the macro is deleted as I assume they are of no interest.
Alf
Bookmarks