Why do columns and rows in the array reverse?

[dejavision]

Hi!

I have a complete reversal of rows and columns in the array, and I can't find a workaround for this.

I'm trying to fill an array with random values, and when I declare an array like this:

Dim Arr(1 To 1000, 1 To 6) As Integer

It is supposed to give me 1000 "rows" and 6 "columns", if I understand everything correctly.

However the following code completely reverses this: it gives me 6 rows, and 1000 columns and I don't understand why. Please help me correct it.

Please Login or Register  to view this content.

Best regards,
dejavision.

[Norie]

Could it be because you are using Application.Transpose?

If I remove that I get 1000 rows and 6 columns of random numbers.

[dejavision]

Could it be because you are using Application.Transpose?

If I remove that I get 1000 rows and 6 columns of random numbers.

Norie, thank you for your swift reply. Yes, I'm a newbie in VBA and it could be because of Application.Transpose. But then why does Application.Transpose reverse them and how can I apply this function or any other method to get the array to the worksheet? In the final code I'm planning to have 1 million rows and I don't know any method except this to do it fast.

Best regards,
dejavision.

[Norie]

Transposing swaps columns and rows.

If you miss it out and just use this your code will work just fine and you'lll end up with 6000 random numbers in 6 columns and 1000 rows.

Please Login or Register  to view this content.

If you want more random numbers just increase the dimensions of the array and then use something like this to avoid hard-coding the range

Please Login or Register  to view this content.

[dejavision]

Transposing swaps columns and rows.

If you miss it out and just use this your code will work just fine and you'lll end up with 6000 random numbers in 6 columns and 1000 rows.

Please Login or Register  to view this content.

If you want more random numbers just increase the dimensions of the array and then use something like this to avoid hard-coding the range

Please Login or Register  to view this content.

Thanks a lot, Norie. I've inplemented your advice and now everything works fine.

Best regards,
dejavision.