![]() |
#2
|
|||
|
|||
![]() 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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AWD | Word | 3 | 10-16-2018 01:10 PM |
![]() |
Dimsok | Word VBA | 18 | 11-14-2014 12:30 PM |
![]() |
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Word delete page if string is not contained | wolfking333 | Word VBA | 0 | 06-23-2013 10:02 AM |
![]() |
dozd | Excel | 1 | 02-22-2013 03:24 AM |