Problem with function to increment array index

[ts_hunter]

I have two sections of code below. I would like to reference the array like I have it written in the first section of code. However that does not work. The second code works, but I would like to do it the other way. Is there something I am missing in the first section that causes the 'i' variable to not retain its value?




-------------------------------------

[June7]

strings(0) = "A"
strings(1) = "B"
For i = 0 to Ubound(strings)
Debug.Print strings(i)
Next

[ts_hunter]

strings(0) = "A"
strings(1) = "B"
For i = 0 to Ubound(strings)
Debug.Print strings(i)
Next

Yes, I know about that method. But I am curious about why my #1 section of code doesn't work. Is there a way to make it work?

[June7]

The first procedure does not increment the public variable i. It never changes from 0. Step debug and you will see that. It needs to be incremented somewhere - either in the sub or the function. Could add this line to the function: i = nexti

[ts_hunter]

This works now that I added ' i = nexti'. I am using this for referencing indexes of an Excel spreadsheet, this function will clean up alot of code where I am doing i = i +1 and j = j + 1 where i and j are the cell indexes. THANKS.