I have very little idea of what you want to achieve as your explanation
is sketchy to say the least, however you don't need to use VBA for you
explanation, you need a worksheet function SUMPRODUCT, the master of
SUMPRODUCT (Bob Phillips) is currently giving tutorials on it here
'SUMPRODUCT And Other Array Functions - VBA Express Forum'
(http://www.vbaexpress.com/forum/forumdisplay.php?f=98)


jay dean;327908 Wrote:
Hello -

Is there a way to perform set operations in VBA? Example: If
rng1=Range("A1:A2000") and rng1=range("C1:C2000") containing strings --
numbers,text or both, is there a way to perform operations like
"intersection", "subset", and "union" that produces a range, containing
the result?

If not, can this be done with excel functions or formulas?

Any help will be appreciated!

Thanks
Jay


*** Sent via Developersdex 'Developersdex.com - The Web Developers
Index and Directory' (http://www.developersdex.com) ***


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91627