Copy Cell and Paste every Nth row

[steven_e]

So I want to copy this group of cells once, then have it paste every 17 rows until the last row (just on the active sheet I am on)

I have my copy code:

Please Login or Register  to view this content.

But what will paste it on row 22 & 23.....then paste on row 40 & 41 -- every 17 rows -- I need it to paste the copying code until the last row of the active sheet.

[Norie]

Give this a try.

Please Login or Register  to view this content.

[steven_e]

That did not work

here is a picture of a spreadsheet to better understand.....I want to copy the highlighted text down (preferably with formatting) to the same spot (17 rows - those are highlighted as well) for as long as there is data in the rows.
excel.png

[Norie]

'not work' in what way?

[steven_e]

it made a copy somewhere along column C about 17 rows below....then I couldnt see the rest. It would just loop continuously until excel locked up and wouldnt respond.

Please Login or Register  to view this content.

[Norie]

In the original post it wasn't 100% clear where you wanted to copy to, you mentioned the rows but not the column.

Anyway, the code I posted copied to column A which can easily be changed.

Please Login or Register  to view this content.

The other thing is that if you want this down to the last row, ie the entire sheet. it will take time and Excel might lock up.

[s3a]

What is the error message the code editor gave you? What happens when you click "Debug"?