An array class for VBA providing features found in more modern languages
u/senipah has done a lot of work extending VBA's array capabilities here. I would look into this to sort your data in memory rather than reinventing the wheel.
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.
What is the best way to import a CSV as a 2D array in Word?
1 project | reddit.com/r/vba | 23 Mar 2021
How to structure my program when I want to carry out multiple actions to a range which changes
1 project | reddit.com/r/vba | 18 Mar 2021
Using Variant to make code more universal
1 project | reddit.com/r/vba | 28 Feb 2021
I'm new with VBA and I cannot sort a 1D array
1 project | reddit.com/r/vba | 18 Jan 2021
🎁 Yii Arrays 2.0.0
2 projects | reddit.com/r/PHP | 25 Oct 2021