I haven't tested, but for data that is already in the worksheet, I would
expect sort to be very efficient. But you can see that Howard Kaikow, with
a similar expectation, had a different experience when testing against a
sort routine in the old Word macro language (not Excel).

http://www.standards.com/

Still, sorting is a bread and butter capability built into Excel.

--
Regards,
Tom Ogilvy

"Jef Gorbach" wrote in message
...

"Johan de Kok" wrote in message
...
I want to create a vba function with as input an unsorted array and as
output a sorted array.

Any idea,

Thanks, Johan



Both are very interesting articles - but raises the question: what is
Excel's Sort Function and/or how does it compare to writing your own sort
routine?; esp when have numerous columns in the sheet.
???