I want to create a vba function with as input an unsorted array and as
output a sorted array.

Any idea,

Thanks, Johan

Roedd <<Johan de Kok wedi ysgrifennu:

I want to create a vba function with as input an unsorted array and as
output a sorted array.

Any idea,

Thanks, Johan


This is the most comprehensive resource I know of when it comes to sorting
in VB

http://www.devx.com/vb2themax/Article/19900

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

Original portions of this message are copyright
Robert Bruce and intended for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

Here is another source:

http://www.visualbasicforum.com/t78889.html

--
Regards,
Tom Ogilvy

"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

"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.
???

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.
???