Populate a Single Dimensional Array with two Dim Array (matrix)

Hola,

I know how to populate a 2 Dim. Array from a worksheet table and how to transpose such an Array.

I wonder if there is a way to populate a Single Dim. Array (vector) with the 2 Dim. array values ?

For example:
How can one populate a 100 size Array from a 10X10 Size Array - WITHOUT using Loops ?

Thanks, Ben

You can't.

The simplest way I know is:

Please Login or Register  to view this content.

But: why would you ?

Thank you.

Let us wait for more replies...

Ben

******************** EDITED *******************
By the way:

The range A1:J10 has 100 cells.

1) How come that the UBound(sn) returns only 90 ?

2) In C01, your code combines J1 with A2 WITHOUT the in-between comma.

I amended the previous code.
Ubound(sn)=10

Do you mean something like

Please Login or Register  to view this content.

About UBound, it takes two arguments, the name of the array and the index being UBounded.
The second argument defaults to 1 if ommitted.
Similarly LBound.

Please Login or Register  to view this content.

Thanks Mike.

Can I assume that there is, absolutely, no way to populate a single Dimmed Array with the content of a Matrix Array, without For-Next Loops through the source Array, and mark the thread as Solved ?

Ben