VBA macro to insert row based upon set format

Hi,

I'm having trouble writing a macro that will work in a number of spreadsheets that are at times not consistent in their formatting.

I need the set repetition of the following:

Date StartHour
Date 6
Date 7
Date 8
Date 9
Date 10
Date 11
Date 12
Date 13
Date 14
Date 15
Date 16
Date 17
Date 18
Date 19

But unfortunately where there are complete gaps in a row of data it is ignored. Is there any vba code to search that this occurs and then insert a row with the correct date and time?

Thanks for any help with this.