I need help adjusting how rows get inserted and deleted with the macro in the attached file. If you click the "Click to Insert" button and enter a positive number. All formulas and formatting in the row above current position of cursor will copied.
If your cursor is positioned in row 4 for example, and you type "-2" in the dialog box, the macro will delete rows 4 and 5 from all select worksheets. I would like to modify this to so that rows 3 and 4 would be deleted instead. I'm fairly certain that this line of the code holds the key to making this happen.
However I have not had any luck properly applying it. If someone could provide a recommendation and explain these two lines, I would be grateful. Thanks!
ws.Cells(sel - 1, 1).Resize(rng + 1, 1).EntireRow.FillDown
P.S. I also attached the excel file that contains the complete code. This should give you a better understanding to question.