Welcome

This is a very old post, so it'd be better and you'll get more responses if you start your own with a 'catchy' title

Quick Sort is recursive, and so it can run out of stack space, esp. with a lot of data



Chip Pearson has a module that does the quick sort in place, that MIGHT be better. I've never used it

http://www.cpearson.com/excel/SortingArrays.aspx


http://www.cpearson.com/Zips/modQSortInPlace.zip



Public Function QSortInPlace( _
    ByRef InputArray As Variant, _
    Optional ByVal LB As Long = -1&, _
    Optional ByVal UB As Long = -1&, _
    Optional ByVal Descending As Boolean = False, _
    Optional ByVal CompareMode As VbCompareMethod = vbTextCompare, _
    Optional ByVal NoAlerts As Boolean = False) As Boolean

If the data is on a WS, I'd just use the WS sort, no size limits and it's fast.

If the data is only in a VBA array, I'd copy it to a temp WS, sort it, put it back into the array, and delete the temp WS