Visual Basic for Applications/Bubble Sort One Dimensional Arrays

Summary
This page deals with the sorting of single dimensioned arrays. These are typically the ones used for placing lists into variants with the Array method. It is more rare to find such a sorting routine in VBA, since most sorting is done in two dimensions.

Bubble Sorting One Dimensional Arrays

 * The procedure BubbleSort1DArray uses the slowest of sorting methods. However, there would seem to be no disadvantage in doing so here, since few lists ever attain great size.  There are options for ascending or descending sorts, and for the method of return.   If a return array is provided, that will be used, otherwise the input array will be changed by returning in that.