(Solved) – Copy row and past into multiple rows

  • by
(solved)-–-copy-row-and-past-into-multiple-rows

I have the following code, that will copy a row and paste it into multiple rows.

For i = 2 To 100
    Rows(101).Copy Rows(i)
Next i

This does work, but it takes a lot of resources, because of the copying is made 100 times.

Is there a way to optimize this code, so that the copying can be made once in advanced, instead of 100-times inside the For-loop ?

Have tried this, but this does throw an error. “Object doesn’t support this property or method”

Rows(101).Copy

For i = 2 To 100
     Rows(i)
Next i

Leave a Reply

Your email address will not be published. Required fields are marked *