How to read the indices from each element of array?

[Kelvin Stott]

I am reading through the elements of an array with a For Each each loop, but how do I read the coordinates of each element in turn as called, for example:

For Each Element in MyArray
x = (first coordinate/index number of Element)
y = (second coordinate/index number of Element)
Next Element

I know that you can do this the other way round and call each element in turn by looping through the indices directly, but is there some function or property to read the "coordinates" or index numbers of each element in an array as called with a For Each loop?

 

[Norie]

Sorry but there's no direct way to do that in VBA.

VBA just doesn't have the same kind of functionality available for arrays as other languages have.

 

[Kelvin Stott]

OK, thanks, at least now I can stop waiting and/or searching for an answer. I guess I just do it the normal way, looping through the indices along each dimension directly.