|
VBA8025集VBA数组之VBA排序算法(上)中,“选择排序”也可以是自上而下的顺序:- Sub 选择排序2() '由jbl增补的程序:从A1单元格开始。
- Dim arr, temp, x, y, t, iMin
- t = Timer
- arr = Range("a1:a10")
- For x = 1 To UBound(arr) - 1
- iMin = x '假设最小值的索引号(此处等于单元格行号)
- For y = x + 1 To 10
- If arr(y, 1) < arr(iMin, 1) Then iMin = y
- Next y
- temp = arr(iMin, 1)
- arr(iMin, 1) = arr(x, 1)
- arr(x, 1) = temp
- Next x
-
- Range("c1").Resize(UBound(arr)) = ""
- Range("c1").Resize(UBound(arr)) = arr
- MsgBox "排序秒数为" & Timer - t
- End Sub
复制代码 |
|