Range Values

[JJ]

Is there a way to return the values from a range without iterating through
each cell using VBA?

Thanks

 

[JulieD]

Hi JJ

not sure exactly what you mean here, could you type out an examle of what's
in the range and what you want to see (and where) from the output and maybe
explain the purpose of what you're after.

Cheers
JulieD

 

[JJ]

A1 has A
A2 has B
A3 has C

I want to get the array back for the range which would be {A,B,C}. Is there
a VBA function command that would return the array for the range A1:A3?

 

[Dave Peterson]

You could put them into a two dimensional array (rows by columns):

dim myArr as Variant
dim myRng as Range
dim iCtr as long
dim jCtr as long

with activesheet
set myrng = .range("b3:c9")
myarr = myrng.value
end with

for ictr = lbound(myarr,1) to ubound(myarr,1)
for jctr = lbound(myarr,2) to ubound(myarr,2)
msgbox myarr(ictr,jctr)
next jctr
next ictr

But I'm not sure what return means.