Excel ranges can be treated like tables in Excel. So you can probably use
ADO to do the same thing.

http://support.microsoft.com/default...b;en-us;278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

--
Regards,
Tom Ogilvy


"Herbert Chan" wrote in message
...
It is an excel file and the data are in separate rectangular ranges.

Herbert

"Bob Phillips" ¦b¶l¥ó
¤¤¼¶¼g...
What is the definition of a set here?

--

HTH

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


"Herbert Chan" wrote in message
...
Hello,

I've a spreadsheet in Excel and I have some data.

I want to be able to extract the data from set1 that are not in set2.
In
Access, that will be a nonmatching query. However, in Excel, how do I
do
it
with VBA function? Any written functions already out there?

Thanks.

Herbert