Hi GezCam,
I am lost here, could you give an example, how do you know are bad email
addresses

"GezCam" wrote:

I have one workbook which lists email addresses. Book 1

I have another workbook which lists the email addresses from Book 1 which
are bad. Book 2

I now want to take out of Book 1 the bad email address but do not want to do
it manually (as over 4000 bad email addresses)

Any ideas please?????