Sub s()
arr = Array(6, 2, 7, 9, 5)
For i = 0 To 3
For j = 3 To i Step -1
If arr(j) < arr(j + 1) Then
t = arr(j)
arr(j) = arr(j + 1)
arr(j + 1) = t
For k = 0 To 4
Debug.Print arr(k);
Next
Debug.Print
End If
Next
Next
End Sub
Sub aaa()
Dim arr, i&, j&, r&, tmp&
arr = Array(6, 2, 7, 9, 5)
For i = 0 To UBound(arr) - 1
For j = 0 To UBound(arr) - i - 1 '冒泡排序从小到大排序,这一句为什么UBound(arr) - i - 1
If arr(j) < arr(j + 1) Then
tmp = arr(j)
arr(j) = arr(j + 1)
arr(j + 1) = tmp
End If
Next j
Cells(i + 1, 1).Resize(, UBound(arr) + 1) = arr
Next i
End Sub