[Solved] Sort the array in my VBA code

gutee · Post by **gutee** » Mon Jan 21, 2019 9:01 am

I have one array, the element is string.
how can I sort the array easily, any function available ?
my_arr(0) = "ccc"
my_arr(1) = "bbb"
my_arr(2) = "aaa"

I need get a sorted array :
my_new_arr(0) = "aaa"
my_new_arr(1) = "bbb"
my_new_arr(2) = "ccc"

Post by **JeJe** » Mon Jan 21, 2019 12:14 pm

https://wiki.openoffice.org/wiki/Sorting_and_searching

Lupp · Post by **Lupp** » Tue Jan 22, 2019 12:39 am

(Why VBA? This is not an MS forum.)

What expectations are there concerning the efficiency? How long (maximum) will the array be that needs sorting?
Will next time probably be accompanying data needing to be included with the sorting?
Is the surrounding application Calc or something else?
How shall 'Empty' data (strings) be treated?

gutee · Post by **gutee** » Tue Jan 22, 2019 3:20 am

Oh, sorry, i'm a beginner. this should be OOo Basic code, right?
Thanks.

gutee · Post by **gutee** » Tue Jan 22, 2019 4:15 am

JeJe wrote:https://wiki.openoffice.org/wiki/Sorting_and_searching

Thanks, this works pretty good!

[Solved] Sort the array in my VBA code

[Solved] Sort the array in my VBA code

Re: Sort the array in my VBA code

Re: Sort the array in my VBA code

Re: Sort the array in my VBA code

Re: Sort the array in my VBA code