Script to Delete Rows

[yvettew78]

Hi Everyone

I am after a function to include in my RESET google sheets script that deletes any rows that the user may have added after row 19. If the user needs to add a new item to the form, they can do that automatically by clicking on a button which I have assigned a script to, to make it insert a new row/item but I want it to reset to the forms original state. There are 27 possible item choices the user can choose so I can't assign a value of how many rows to delete as it will vary each time the form is used.

Can anyone help with this please?

Thank you.

 

[Michael M]

Which column would hold the "extra" data that needs removing.
Maybe something like this

Sub Delrow()
Dim lr As Long, r As Long
Application.ScreenUpdating = False
lr = Cells(Rows.Count, "A").End(xlUp).Row
    For r = lr To 20 Step -1
        If Range("A" & r).Value <>"" Then Rows(r).delete
    Next r
Application.ScreenUpdating = True
End Sub