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

Please Login or Register  to view this content.

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.

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.