You can assign it to a variant variable
Dim v as Variant
in xl2000 and later you can also assign it to a dynamic variant array
Dim v() as Variant
However, assigning it to a variant works as well and is compatible back to
excel 5 where vba was introduced.

Dim v as Variant
v = Range("A1").currentRegion.Resize(,2).Value

for i = 1 to ubound(v,1)
for j = 1 to ubound(v,2)
debug.print i, j, v(i,j)
Next
Next


--
Regards,
Tom Ogilvy

"-JEFF-" wrote in message
...
I need to assign dimension 1 with col A data and dimension 2 with col B
data.
IOW, element 1 would consist of A1, B1, element 2 A2, B2... The number of
rows is not always the same. Can somebody provide an example of code to
accomplish this? Thanks! -JEFF-