Inserting Lines using multiple Macros

[P_Kellogg]

I'm able to create a macro that allows me to insert additional lines to a
template as a user needs with no problems. Further down in the sheet I have
an additional macro to insert additional lines as a user needs. If the user
inserts lines with macro #1 and then tries to insert lines with macro #2, the
second macro now has inaccurate row references and places the additional
lines in the wrong location. Is there a way to have the line insertion point
move if additional rows are added above the macro?
Thank you in advance for the support.
Paul

 

[dan dungan]

Hi Paul,

You'll probably have a more useful experience if you post the code
from each macro.

Dan

 

[mdmackillop]

As with deleting rows, its best to insert from the bottom up.

Try these 2 codes in a block of data to see the difference
Sub Inserts()
For i = 20 To 2 Step -2
Rows(i).Insert
Next
End Sub


Sub Inserts2()
For i = 2 To 20 Step 2
Rows(i).Insert
Next
End Su