macro amendment so that it loops

[mattbloke]

Hi all,

I have a small issue i am sure one of you will solve extremely quickly.

In each row in column A I have a start date and in each row in column B I have an end date (no set number of rows). What I want is for the list of dates between these 2 dates to be listed in the corresponding cells in column C onwards.

I have code to do row 1 which works perfectly (see below) but this does not loop ( I want it to loop until it reaches a blank cell).

Please Login or Register  to view this content.

Your help would be hugely appreciated.

Many thanks, matt

[MarvinP]

Try this:

Please Login or Register  to view this content.

[mattbloke]

Hi Marvin,

Thanks for your extremely quick reply. This works fantastic. I hope to use these forums to develop my knowledge of VB so I can answer my own questions in the future!

Many thanks, Matt