Guzzlr
Well-known Member
- Joined
- Apr 20, 2009
- Messages
- 982
- Office Version
- 2021
- Platform
- Windows
HTML:
For Each sht In ActiveWorkbook.Worksheets
If sht.Visible And (sht.Name = "Ramp") Then
sht.Activate
End If
For r = Cells(Rows.Count, "M").End(xlUp).Row To 7 Step -1
If Cells(r, "M").Value <> "Ramp" Then Rows(r).Delete
Next r
End If
Hello All.
I'm trying to delete an entire row, if the word "Ramp" does not appear in column "M", beguinning on row 7...but I cant seem to get my End If and Next r in the proper place
Can someone lead me in the right direction please
Thank you