|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test0()
- Dim ar, i As Long
- ar = Range("A1").CurrentRegion.Value
- For i = 1 To UBound(ar)
- BubbleSort ar, 2, UBound(ar, 2), i
- Next
- Range("K1").Resize(UBound(ar), UBound(ar, 2)) = ar
- End Sub
- Function BubbleSort(ar, l As Long, u As Long, pos As Long)
- Dim i As Long, j As Long, Flag As Boolean, swap
- For i = l To u - 1
- Flag = True
- For j = l To u + l - 1 - i
- If ar(pos, j) > ar(pos, j + 1) Then
- Flag = False
- swap = ar(pos, j)
- ar(pos, j) = ar(pos, j + 1)
- ar(pos, j + 1) = swap
- End If
- Next
- If Flag = True Then Exit For
- Next
- End Function
复制代码 |
评分
-
1
查看全部评分
-
|