Insert X Rows per Value

[JohnTaitor]

Hello everyone,

I`m search for a way, how to insert for example after A2 a number rows after it. The number how often he had to insert the row is set on a value. I already built a method, but I dont know why, it has problems with inserts over 3-4.

Here is the code #1:

Please Login or Register  to view this content.

Code #2:

Please Login or Register  to view this content.

Has someone a better solution or a fix of my code above?

[mohadin]

HI
What about

Please Login or Register  to view this content.

[mohadin]

Or may be

Please Login or Register  to view this content.

[JohnTaitor]

A question: What does the attributes (x) in "Cells(x, x)" stands for?

[mohadin]

HI

Please Login or Register  to view this content.

Cells(1,1)= Range("A1")
Cells(2,1)=Range("A2")

cells(1,2)=range("B1")