Forgetful Arrays

Greetings!
I'm starting to experiment with arrays to expand my vba proficiency and decided to see if I could use an array to count the number of instances of a bunch of entries in a list. This obviously could then be used to show duplicates or unique values etc. etc.
I know there are likely more efficient ways to do it - it's not really about the end goal but more about figuring out how to use arrays!

Anyhow, I have the following code:

Please Login or Register  to view this content.

This is what I get from th

0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
0	Number of instances of 0: 0
7	Number of instances of 7: 1

So, for some reason it only remembers the last entry to the table - which is the 7. Everything else seems to get forgotten along the way.
What am I doing wrong, and do you have any generic tips for dealing with arrays where I'm going horribly wrong? I know it's inefficient to keep redefining the array - could I possibly set the array size from the start to be the total number of entries in the sample I'm analysing (which obviously would be the max number of inputs if there were zero duplicates) and then resize it smaller to match the number of actual entries to the array?
Any suggestions would be appreciated!
Thanks,
Lady Marmalade

Redim deletes all existing contents of an array.

So:

Please Login or Register  to view this content.

Deletes all the current entries and resizes the array.

You really want

Please Login or Register  to view this content.

However it won't work since you can only resize the final dimension of the array ie. 2.

Might also be worth noting that arrays are indexed from zero unless otherwise specified, so Redim Something(2) has 3 "spaces".

Ah yes, I forgot that arrays started at zero.
The issue was that when I try using ReDim Preserve, it comes up with the "subscript out of range" error, hence why I deleted it. Any reason why this'd happen?

Yes, I told you in my post above

Right, I hadn't quite understood properly. So really, my best bet is to just switch the whole thing over - i.e. have it be summary(2, size) instead?
I'll give that a try and get back to you. Thanks!

Yep, or use a collection/dictionary.

This isn't particularly a good example for learning arrays with since it's hard and there's a lot to consider.