sort function vba
 

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

Any idea,

Thanks, Johan

sort function vba
 

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.

sort function vba
 

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

sort function vba
 

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

sort function vba
 

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