How to Create a Data Entry Form to ADD and REMOVE Rows in Excel

[@JopaExcel]

CODE to copy and paste: Sub DELETEROW() Dim ws As Worksheet Dim row As Long Set ws = ActiveSheet row = ws.Range("B6").Value ws.Rows(row).Delete MsgBox "row " & row & " deleted successfully.", vbInformation End Sub

[@maheramhaz]

the script provided has only one row to adjust and it is different what is shown on your macro