Insert Copied Rows every 40 lines

[adwatson]

Hi All,
I have searched but was unable to find what I was looking for. I have a set of rows that I have copied in an Excel table. I then want to insert these copied rows every 40 lines but with a user input box that lets you choose which row to start at. For instance user can input row 45 and copied rows will be inserted there, then move down 40 rows and insert again and repeat until Col B is blank. Any help would be greatly appreciated, I am still learning to use loops.

Thanks!

 

[Marcelo Branco]

Ok you have been a ton of help. I actually modified your original code and got it to insert the headers every 40 lines and this is working perfectly! Thanks so much!

Great!
I'm happy that you figure it out and everything is working perfectly.

All the best

M.