View Single Post
  #2   Report Post  
Posted to microsoft.public.access.modulesdaovba,microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default VBA Function that mimics the Access Not Matching Query

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