View Single Post
  #1   Report Post  
GregR
 
Posts: n/a
Default Copy/Insert rows with formulas

I have a macro that copies the last entered row and inserts rows based
on a number from an input box. It works great except two of the rows I
want the copied formulas to increment to the next value and two of the
rows not to increment. Right now all of the rows increment. The
inserted rows start at row 8 and are incremented by the number in the
input box. Also, if I wanted the input box to default to the value in
"C2", how would I do it? TIA

Greg