Look in the vba help index for FIND (FINDNEXT if more than one). Then a for
each loop
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"ddethomas" <(E-Mail Removed)> wrote in message
news:12B4F7F7-17F2-4031-8F6B-(E-Mail Removed)...
> Hello There,
>
> I'm new to these parts and I'm hoping someone can help me. I have a simple
> email list of 4000 addresses (List A) and some are no good. I've made a
> separate list (List B) of those and want to delete all of them from the
> initial list (List A). Is there a way of doing this without doing it
> manually? A formula of some sort? Thank you for your help.