I would use conditional formatting on the long list with a formula to test
if in the short list.

So assume the long list is Sheet2!A1:An, short list is Sheet1!A1:A10.

Select the long list, and in CF, add a formula of
=ISNUMBER(MATCH(A1,Sheet1!$A$1:$A$10,0)), and format with a colour on the
pattern tab.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Arjan" wrote in message
...
I've a workbook with names in range A1:A10.
In another workbook there is a list (the length is every week different)
and
I want to compare this list with the 10 names on my first worksheet.

I want a list of the people who are in that long list, but not in my
default
10 names.

I started with

For Each c In Range("[document.xls]Sheet1!E1",
Range("[document.xls]Sheet1!E65535").End(xlUp))

but that doesn't work. I don't have any idea how to solve this.

Can somebody help me or is it not possible?

Regards,
Arjan