delete rows of specific value or sign

I am using excel2003

I am try to delete all row in sheet1 that have the sign "..." in column b.

I refer below thread which is similar
http://www.excelforum.com/excel-prog...fic-value.html

& I try it with necessary changes but those row not delete. I am attach sample file. In that file from row 186 to 214 in column B at the end of part number "..." (three dot) show. I want those row deleted.

Does this help ?

I added a wildcard to the value to lookup and col changed to "b" in Roy's code

Option Explicit
Sub delAll()

Dim lRows As Long
Dim sFormula As String
Dim i As Long
Dim rDelete As Range

    'count the rows to operate on
    lRows = Cells(Rows.Count, "b").End(xlUp).Row
    For i = 2 To lRows
        If Cells(i, "b").Value Like "*..." Then
            If rDelete Is Nothing Then
                Set rDelete = Cells(i, "b")
            'build range to delete
            Else
                Set rDelete = Union(rDelete, Cells(i, "b"))
            End If
        End If
    Next i

    ' delete any matched rows
    If Not rDelete Is Nothing Then rDelete.EntireRow.Delete
  
End Sub

First time i have run & found row 186 to 214 deleted. But after that again second time i have given trial & changes in row 2 to 4 with same "..." sign after that i have run the prog. but found those row are not delete. Anything wrong with oprating prog.

Attach file for your ready ref.
Thanks for early reply.

Sub Find_and_Delete()
Dim rngCell As Range
Const strFind As String = "..."

Application.ScreenUpdating = False
With Sheet1
Set rngCell = .Range("B:B").Find(what:=strFind)
Do Until rngCell Is Nothing
rngCell.EntireRow.Delete
Set rngCell = .Range("B:B").FindNext
Loop
End With
Application.ScreenUpdating = True

End Sub




The above code will search for "..." in All of Column B and delete all of the rows containing "..." in colum B. It doesn't search that it ends in "..." so if you have another cell with "..." say in the middle it will delete aswell.