Question

excel vba 内存数组按升序排序，试了几次很困惑，哪位大侠能详解，或者字典排序，十分感谢！

Answer 1

提供一个比较普通的数组冒泡排序方法

Sub ABC()
arr = Array("d", "g", "v", "p", "a")
For i = 0 To UBound(arr) - 1
For j = i + 1 To UBound(arr)
If arr(i) > arr(j) Then
Temp = arr(j)
arr(j) = arr(i)
arr(i) = Temp
End If
Next
Next
[a1].Resize(1, UBound(arr) + 1) = arr
End Sub