My bad. The line

If Not IsError(Application.Match(Range("A" & i).Value, myList)) Then

should be

If Not IsError(Application.Match(Range("A" & i).Value, myList, False)) Then

Sorry about that.

HTH,
Bernie
MS Excel MVP


"username" wrote in message
...

This seems to work well - for which, thanks.

The only issue is that if I specify in myList array (for example) "a",
"b", "c" & "d" as the characters to search for and I put in another
character into one of cells after A21, for example "s", when I press my
'Delete Row' button it also deletes the "s" as well as any of the
specified characters. Any ideas how to make it only delete those
characters/words that I have specified in myList?

Thanks again.


--
username
------------------------------------------------------------------------
username's Profile: http://www.msusenet.com/member.php?userid=1433
View this thread: http://www.msusenet.com/t-1870445735