Sorting large volumns of data

[j_Southern]

I have a worksheet that is 20 columns wide and can contain between 20000 and 30000 rows.
Each row has to be sorted independently of the others.
I tackle this in VBA by selecting each row in turn and using the Excel sort procedure.
With 30000 rows this takes about 5 minutes.
It has occurred to me that it would be much faster if I created an array for the data and then sorted each row of this. I don't think that I will then be able to use the Excel sort procedure though.
Can anyone please suggest a way forward. Is there a VBA Sort command, (I have not found one), for instance.
John

[buran]

Hm, how exactly do you sort a single row?

[j_Southern]

Buran
A row with the following aaverftyu would sort to aaefrtuy without reference to any of the other rows.
John

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[j_Southern]

John
Thanks for your interest. Your solution is much the same as the one I am currently using. It works but takes a long time. I am assuming that this is because the code is repeatedly having to refer to the worksheet for each I.
What I think I want would have something like

Please Login or Register  to view this content.

It is the line SORT(SortArray(I,20) that I am hoping to find
John

[j_Southern]

I have just realised the importance of Application.ScreenUpdating = False and am going to try it
John

[j_Southern]

Just for interest as this is an old post now. I loaded the data into an array, and then sorted each row using a bubble sort algorithm I found on line. Then I loaded the sorted array back into the worksheet. With 25000 rows with each row being about 40 columns long (The rows all varied) the sort took about 2 seconds. Done using the Excel sort command by selecting each row from the sheet first the sort could take from 4 to 6 minutes. This was presumably due to the time taken to continually access the worksheet as I think the sort command is very fast in its self.
John

[JOHN H. DAVIS]

Thanks for sharing that. I for one can surely use that info for future reference.