Hi there,
I am using a add button to drop down rows, however since there are so many add and delete buttons, everytime I insert a row via add button, it changes the row number.
For example,
Sub InsertRows()
Rows("8").Insert Shift:=xlDown
End Sub
Sub DeleteRows()
Rows("8").Delete Shift:=xlDown
End Sub
If I put in 5 more like that, it messes up my formatting for the other rows. Is there any way around this?
Thanks,
Newb
Bookmarks