VBA to repeat macro x times

[cossie2k]

Hi Everyone,

I have a macro as below

Please Login or Register  to view this content.

Its basically looking for "Task 1" and then inserts a line underneath, copies the line from above and adds a day to start and finish.

I want to be able to repeat this 21 times, so that I end up with 21 "Task 1"s with a start date over 21 days

I have tried a couple of loops but I cant get this to work.

Does anyone have any ideas?

Thanks
Alex

[ihmha]

Try this

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[cossie2k]

thanks for the super quick responses!

ihmha - Im trying this out at the minute so will let you know
JOHN H - I get an error with this - Its a compile error (Next withoutFor)

Ill try to build on these.

Thanks again
Alex

[JOHN H. DAVIS]

Note code in Post#3 was edited. Current version should not produce an error.

[cossie2k]

Apologies for the delay in getting back to you both, both of these work a treat.

Ive actually gone with ihmha's suggestion as it seems to fit my requirements better.

Thank you both so much for your help
Alex