My For/Next Loop is going too far - why?

[TheRedCardinal]

I have a really simple code:

For Counter = 1 To UBound(SCols, 1)

    FinalArray(1, Counter) = SCols(Counter, 1)

Next Counter

The size of my arrays (as per the locals window) are:

• Final Array, 1 to 133, 1 to 14
• SCols, 1 to 14, 1 to 3

When I hover over "UBound(SCols,1) I get 14.

I know that the counter will loop to 15 but then shouldn't execute the code inside the For/Next loop.

I use these loops all the time and haven't seen this issue before.

But now my counter is 15 and it's trying to populate my FinalArray at (1,15) which obviously doesn't exist.

Have I done something very stupid?

****Update****

I have just stepped through and it's even more strange. When it gets to the code above, Counter is Empty.
In the 1st iteration of the loop, it is set to 14, and not 1?

****Update 2****

I went back to basics and declared my variables (I didn't originally because this is just testing code) and declared Counter as Long and now it seems to work ok, but why?

 

[Jeffrey Mahoney]

Long is the most efficient for Loops. VBA has less thinking in terms of worrying about busting the maximum and it is an integer. VBA could be storing the counter (variant) as something other than an integer. I tried to duplicate you problem and could not get the issue you have.