VBA loop help

Hello,

I am looking to produce a list as follows

Week 1
Week 1
Week 1
Week 1
Week 1
Week 1
Week 1
Week 2
Week 2
Week 2
Week 2
Week 2
Week 2
Week 2
etc

Basically the week number is listed 7 times before incrementing by 1.The whole process would begin on row 2
This continues on until the column previous does does not have any data in it ( a blank cell)
How would i do this? Looking to do this byVBA

Help much appreciated.

Kind Regards,

Please Login or Register  to view this content.

...where A2 represents the topmost cell in the column to left.

If you just want the text rather than formula...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is ace Thank you. Worked a treat.

Originally Posted by jhren

Please Login or Register  to view this content.

...where A2 represents the topmost cell in the column to left.

Thank you, just tested this works a treat to. Many Thanks for your response.

Originally Posted by squirrely

This is ace Thank you. Worked a treat.