Deleting row based on cell value

[b1gdummy]

I've seen several posts on how to do this, but in each of these situations the cells used for deleting had one piece of information in it. I have cells that have a long string of values and I need to delete the row for a specific part of the string. This is what one cell looks like:

$< +Q .A .B .C .E .F .G .H .P .W 092!B 0PVNV 0WLBA A00 DPA G! I# M2CC W.

<colgroup><col></colgroup><tbody>
</tbody>

I need to delete any row where this cell, call it column H, contains the ".C" value in the string.

 

[VoG]

Try

Sub test()
Dim LR As Long, i As Long
LR = Range("H" & Rows.Count).End(xlUp).Row
For i = LR To 1 Step -1
    If Range("H" & i).Value Like "*.C*" Then Rows(i).Delete
Next i
End Sub

 

[b1gdummy]

Worked great. Thanks for the quick response.