Look in the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

" wrote in message
oups.com...
I have a column in one worksheet and a column in another worksheet
(both in the same workbook). The list is huge and I need to check one
column against another for duplicates and remove the duplicate from
one column

Worksheet 1
A101111
A101222
B023455
B334455

Worksheet 2
A102222
A101222
B023333
B224455

How do I create a formula to look up the duplicate and highlight it so
that I can delete it from worksheet 2?

Thanks