Adding Missing Dates In A Column

  • [SIZE=12px]Hi,

    I am stuck on this problem and I just cannot get my head around it.

    I have a column (column A) with a list of dates, in date order ascending.


    Column A

    How can I insert the missing dates using a for-next loop in VBA please - I need to add a new row for each new date as other columns have data in them?

    So, I need to add 02/02/18, 03/02/18, 04/02/18 etc, etc.

    This is the code that I have got, but it gets stuck in a loop and basically doesn't work![/SIZE]


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!