Delete rows macro question

[Jazzer]

Hello,

I would like a to know which code I could use in order to delete rows based on criteria...

data starting in row 9

any cell in col b containing NCEB = Delete entire row
any cell in col b containing NCEL = Delete entire row
any cell in col h containing US GOVERNMENT BOND = Delete entire row
any cell in col h containing DO NOT USE = Delete entire row

Many Thanks

 

[VoG]

Try

Sub test()
Dim LR As Long, i As Long
LR = Range("B" & Rows.Count).End(xlUp).Row
For i = LR To 9 Step -1
    If Range("B" & i).Value Like "*NCEB*" Or Range("B" & i).Value Like "*NCEL*" Or Range("H" & i).Value Like "*US GOVERNMENT BOND*" Or Range("H" & i).Value Like "*DO NOT USE*" Then Rows(i).Delete
Next i
End Sub