Option Compare Text Sub 排序() Dim Arr, Temp, ArrTemp Dim i%, j%, Count Arr = Sheet1.Range("A1:A12") Count = UBound(Arr) '冒泡排序 For i = 1 To Count - 1 For j = i + 1 To Count
If Arr(i, 1) > Arr(j, 1) Then Temp = Arr(i, 1) Arr(i, 1) = Arr(j, 1) Arr(j, 1) = Temp End If Next j Next i Range("C1").Resize(Count, 1) = Arr End Sub