Sub Delete()
Dim r As Range
Set r = Range("a:a").Find(what:="TOTAL", LookIn:=xlValues, lookat:=xlWhole)
If Not r Is Nothing Then Range("a16:a" & r.Row - 1).EntireRow.Delete
End Sub
Sub Delete()
Dim r As Range
Set r = Range("a:a").Find(what:="TOTAL", LookIn:=xlValues, lookat:=xlWhole)
If Not r Is Nothing Then Range("a16:a" & r.Row - 1).EntireRow.Delete
End Sub
Sub Delete()
Dim r As Range
Set r = Range("a:a").Find(what:="TOTAL", LookIn:=xlValues, lookat:=xlWhole)
If Not r Is Nothing Then Range("a16:a" & r.Row - 1).EntireRow.Delete
End Sub