Code to Copy Data to Every nth Row

Hello to all of you,


I have some code that I cannot get to work. Maybe the problem lies with LR.

On Sheet7 of my WorkBook, I have Data in Cells AB1 and AC1 which I want to copy to Cell C11 and D11 respectively, and then down every 4th Row but not further down than Row719.

Please Login or Register  to view this content.

Can someone please help me out here?

Thank you!

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Regards

Thank you guys,


Hello snb,

Hope you have enjoyed a wonderful festive season. Your code is very close to what I want. The only thing is that it goes way beyond Row 719 which is were I want to stop, otherwise it corrupts data further down Columns C & D.
It also runs slow.

@ TMShucks,

I have tried that, and it does not stop at Row 719. Most of the time it will only paste the data in Row 114.

Maybe best if you post sample an indicate the start and end positions.

Regards

Thank you TMShucks,

Here you go. I did not include my non working vba code.

Thank you for your time, and willingness to have a look at it for me!

In this sample sheet7 as referred to in my post will of course be Sheet1.

Please Login or Register  to view this content.

Hallo snb,

Baie Dankie,

That is what I like about you. You seem to be like a Pitbull. Once you take hold of something you don't let go!!!

Your code works perfect, Short and sweet and fast. All I had to do was to change the 708 to 712 to get it working down to row 719. I shall promptly mark the thread as solved.

May I suggest you seriously consider adding this to your samples of code on your Site.

Thank you so MUCH!!!