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