I have a vba code which calculates over 2 million numbers and puts them into an array. I want to sort these values inside the array. As far as I can see there is no sort function in excel vba.
I tried Qsortinplace which can be found http://www.cpearson.com/excel/SortingArrays.aspx
But it seems it doesnt work when there are 2 million members inside the array.
I guess something can be arranged when filling the array in the first place.
What is the best way to sort the huge arrays?