The simplest thing would be to point you to Ron de Bruins site 'Delete
row if a specific value exist (VBA)'
(http://www.rondebruin.nl/delete.htm) here he delets items if they are
in the array, so you can put the unwanted items in the array, or put the
wanted items in and change:
If FoundCell Is Nothing Then
Exit Do
Else
FoundCell.EntireRow.Delete
End If
For:
If FoundCell Is Nothing Then
FoundCell.EntireRow.Delete
Else
Exit Do
End If


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7657