Hello all,
I have a table that gets a row added each time a command button is pressed; However, because the table is auto-sorted, the row moves unreliably to different numerical rows. How would I add a second command button that will delete the last added row (almost like undoing the add command button)?
see the add command button below:
Sub CommandButton1_Click()
Application.EnableEvents = False
With Sheets("Maintenance Reporting Page")
.Range("B15").EntireRow.Insert Shift:=xlDown
.Range("E15").Value = Format(Now, "dd-mm-yy")
End With
Sheets("Maintenance Reporting Page").Range("B14:H14").Select
Selection.Borders.Weight = xlThin
Application.EnableEvents = True
End Sub
Bookmarks