Array

E

excel

Hi,
is it possible to create an array from all values of all range in a
selection?

Thanks
 
B

Bob Umlas

Sure:
Dim MyArray as Variant
MyArray=Range("A1:F3")
msgbox Ubound(MyArray,1) 'should say 3
Msgbox Ubound(MyArray,2) 'should say 6
Range("F5:K5")=MyArray 'will copy items to this new range

Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to read Excel Array to vb.net Arrays? 20
Array to Multiple Arrays 3
Arrays and scattered cell values or another way? 16
Error with calling Format sub 7
Copy Array to Array, how to and should I? 13
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Permutations andText to column problem 6
add a specific slide to an array of slides 0

Top