Sorting array variable elements ascending

[Gabor]

Long time no talk.

There is a table with 1500+ rows, in a column I have 'Product Line', there are about 50 possible entries, no empty cells.
I have made Dim ProdLines(1 to 50) get loaded reading those 1500 plus cells in that column and listing the actual different entries.

Now I need to sort the array elements ascending.

Any better, or more elegant method for that than below?

Please Login or Register  to view this content.

[DonkeyOte]

see: http://www.cpearson.com/excel/SortingArrays.aspx

I have often used the QSortInPlace routine.

[Gabor]

That was quite sofisticated.
Thanks