Somehow turned 1-dimensional array into 2D array .....dont know how

[welchs101]

Question:
I have this 1D array that after i "sort" it using my own sort function the array comes back as 2D. Now how do i know it comes back as 2D.

If i dont do my special sort function i can reference the array as "array_file1(x)" where x is variable.

If i do my special sort function i MUST reference the array as "array_file1(x,1)" where x is variable.


I am enclosing the part of my code that does the sort and does the initializing of the arrays.........



Now in my sort i paste the array into the worksheet and then do the sort then read the worksheet into array. So my guess is reading the worksheet data inot the array is somehow causing this change.........but i dont understand why. Her eis the command i use to store the values into the array from the worksheet

Please Login or Register  to view this content.

so my question is why does my array go from 1d to 2d and what command do i need to change to keep it 1d. its not that the 2d is bad its just that this was unexpected and took me a little while to figure out.

[Andrew-R]

I think if you assign a range of values to a variant it automatically becomes a 2D array.

I guess the workaround would be to read the range values in one by one, but if you can live with the array being 2D then it's a neater solution.

[shg]

Why not use a simple sort routine that doesn't convert the array to 2D? I posted one for you a few days ago.

[snb]

You transform an array into a Range (in a worksheet).
A Range is always 2-dimensional.
If you read a Range from a worksheet into an array the array will have the same dimensions as the Range (2-dimensional).

[welchs101]

thanks to all who responded.


shg,
I created this sort method before you pasted the code on the sort. I will look at the sort info you posted again and use it.

thanks.

[snb]

To turn a range into a 1-dimensional array:

Please Login or Register  to view this content.