"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

I have a VBA Sub which, given two ranges even in
two sheets, makes the following comparison:
A-B === elements in range A that are not in range B
B-A === elements in range B that are not in range A
A+B === elements of A plus elements of B
AB === elements that are common to A and B
Unique values only.

It is one page code. Do you think it is ok for you?

Ciao
Bruno