Extracting columns from multidimensional arrays
If I have a two-dimensional array and it has assigned the values of a two-dimensional range, is there any way I do something to a whole row of column, whithout using a loop?
For example
Dim myArray(), myVector()
ReDim myArray(1 To 100, 1 To 3)
ReDim myVector(1 To 100)
' Copy column 2
For i=1 To 100
myVector(i)=myArray(i,2)
Next i
Why can't I just do something like
myVector(1 To 100)=myArray(1 To 100,2)
Thanks!
Re: Extracting columns from multidimensional arrays
i would believe you can do like that using the copymemory API
i remember a thread that showed how to transpose a 2d array using copy memory, but it is not something i am familiar using, so you might have to do some searching