Array

  • Thread starter Thread starter excel
  • Start date Start date
E

excel

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

Thanks
 
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
 
You must log in or register to reply here.

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
Copy Array to Array, how to and should I? 13
Arrays and scattered cell values or another way? 16
Permutations andText to column problem 6
Error with calling Format sub 7
Open a GroupWise .NAB File 6
Strange pasting array to cells behavior 2

Back
Top