I have a form to incude retail items to a quote. I created a button at the bottom of the form to enable users to add an additional row if they need to include additional retail items. I used the record Macro function to insert a new row and then fill down the formulas.
My problem is that the range referenced is Row 8. I have selected that row because it is the last row directly above the button. However if I need to run the macro again, my new row is again in row 8. I want it to where after adding a row previously, I the new row shows up in row 9. How do I get the range to adjust everytime I hit the button to run the macro?