Referencing Elements within an Item in a Collection

[anthony.mcgovern]

I'm having trouble referencing elements within items I passed to a collections array. Essentially, I read each cell in a row within a 1092x6 table as an item in a collection. Now that all the cells are stored as elements within each item in a collection, I don't know how to reference each individual element.

Here's the code:

Please Login or Register  to view this content.

For example, I'd like to be able to print the first value of the first item of the collection to the Immediate Window, like this:

Please Login or Register  to view this content.

That doesn't seem to help me reference each individual element in an item within a collection. What am I missing?

[JBeaucaire]

You don't specify why you want to address each item into a collection. A regular array does this and seems to immediately allow you to address the items in the array by X Y coordinates:

Please Login or Register  to view this content.

[WHER]

Regarding your Collection, try

Please Login or Register  to view this content.

[anthony.mcgovern]

Thanks for the feedback, JBeaucaire. There are three reasons that I'd like to add those elements into a collection:

• Ability to filter elements before adding them to the collection,
• Manipulating collections in memory is better for performance,
• Collections have keys associated with them, which means I can reference elements in a collection without knowing what position it's in
  

With a large data set, it would be good to be able to reference certain elements just by referencing their keys. What do you think? Are there benefits to arrays that I'm missing?

WHER: Thanks. I'll try that out.