How to address elements in variant array?
And I'd use lbound, too:
For I = lbound(ary,1) To UBound(ary, 1)
For J = lbound(ary,2) To UBound(ary, 2)
Why remember if/when the array is 0-based or 1-based or something else based.
David wrote:
Dim rng As Range
Dim ary As Variant
Set rng = Range("A1:C10")
ary = rng.Value
How to loop through array and read/modify/delete elements
I've tried variations on the code below, but no joy so far...
For i = 1 to ubound (ary(1))
For j = 1 to Ubound(ary(2))
msgbox ary(i,j)
next
next
--
Dave Peterson
|