D
David
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
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