Array within Array within Array, Possible?

[Bob1980]

Hey All,

I'm getting stumped on a concept, and was wondering if this is possible. Can I have an array with the following dimensions?

ArrayGroups ( 1 to k)
ArraySubGroups (1 to j)
ArrayPointsinSubGroups (1 to 3)

where array SubGroups is comprised of mini arrays of ArrayPointsinSubGroups
and ArrayGroups is comprised of the SubGroup Array?

This might make it easier to understand:
ArrayGroups( 1k(ArSubGroups1(ArPointsinSubGroup1,ArPointsinSubGroup2,ArPointsinSubGroup3) _,ArSubGroups2(ArPointsinSubGroups1,ArPointsinSubGroup2,ArPointsinSubGroup3) _
,ArsubGroups3(ArPointsinSubGroups1,ArPointsinSubGroup2,ArPointsinSubGroup3)))

It's almost like a dream within a dream within a dream...I can't believe I get to use my "Inception" quote.

I basically have a lot of data to analyze and the hard part about it is that there can be a lot of different types of data. Sorry, due to my confidentiality agreement, I can't get any more specific.

Thanks,
Bob1980

[JosephP]

yes it's possible-if your arrays are declared as variants you can store anything in them. it seems likely that a setup using classes and collections will be better but that's your call

[AB33]

Jay,
I thought there is another name by Josephp, it is only when I saw your signature I realise that it the same person. I am losing tacking your photo collection.

[Bob1980]

Hi JosephP,

Thanks for the nudge. I went ahead and built 3 Collections, and below is the code. What I did was that I build 3 separate collections for 3 types of colors.

These are the arrays that are compiled before the compiling of the collections:
xx ()
Part1()
Part2()
*Note: I changed the names of the Part1() and Part2() due to confidentiality, the actual array names are different.

What the challenge for me now is that I don't know what colors will be in a set of data; but what I do know is all of the possible colors that may be in the data. My initial thought was to use the Part1() to call or hash/loop through all of the collections, thinking this would print only the collections that are filled. But, the items in the Part1() are strings and VBA won’t allow me to compare the Part1()items to the name of the collection. Can you offer a nudge that will allow me to dynamically choose which collections to fill; or a way to prompt specific collections to print based upon the colors detected?

Please Login or Register  to view this content.

Thanks for the help.
Bob1980

[Bob1980]

JosephP,

I think I can create a collection out of these collections, and name the key a "string". With that being said, I might have this down...hopefully. lol. I'll look into this, but still wouldn't mind your feedback, or anyone else for that matter.

Thanks,
Bob1980

[shg]

I think you need to explain clearly what your data is and what you're trying to do with it.

[Bob1980]

Hi shg,

Sorry, I don't feel comfortable doing that, but what I can tell you is that I've successfully merged my collections within a larger collection. And I'm trying to figure out how to print from the larger collection, rather then building a whole bunch of if statements.

ThanksBob

[shg]

OK, good luck.