Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Is there a one-liner (I'll consider a two-liner for half price) in VBA that takes two or more collections and forms their intersection or union? I know about the Intersect and Union methods, but those only take ranges as arguments; I'm interested in forming intersections and unions of collections in general. E.g., if X, Y, and Z have been declared as New Collection, I've added objects to both X and Y, and now I want to quickly set Z equal to the collection that consists of those objects that are members of both X and Y. Thanks, Robbie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i create chart like branch-sector sales & collections | Excel Discussion (Misc queries) | |||
minimize the file size in a ppt with collections of many pivot tables | Excel Discussion (Misc queries) | |||
Creating Collections 'on the fly' | Excel Programming | |||
Value at Intersecting cells | Excel Programming | |||
Value at Intersecting cells | Excel Programming |