View Single Post
 
Old 01-09-2019, 09:09 PM
Kenneth Hobson Kenneth Hobson is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

Code:
Sub rdRowM1()
  Dim r As Range, f As Range
  Set r = Range("B2", Cells(Rows.Count, "B").End(xlUp))
  Set f = r.Cells(r.Rows.Count, 1)
  Set f = r.Find("REVERSE DIRECTION", f, xlValues, xlWhole, xlNext)
  If f Is Nothing Then Exit Sub
  With f.Offset(1)
    If .Value = "" Then .EntireRow.Delete
  End With
End Sub
Reply With Quote