How would one go about using a For Each Loop to the second dimension only? It'd be easy to do it with UBound and LBound with a For Loop but I'm struggling in getting this to work with a For Each Loop.
[CODE]
i = 1
j = 1
For Each j in Arr (i, j)
Debug.Print Arr(i, j)
Next j
[CODE]
Obviously it's not recognising the upper limit in the 2nd dimension. Surely it's possible to use a For Each Loop on the 2nd dimension in an array?
Bookmarks