View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
P_Kellogg[_2_] P_Kellogg[_2_] is offline
external usenet poster
 
Posts: 2
Default Inserting Lines using multiple Macros

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