|
发表于 2015-7-24 19:11
|
显示全部楼层
本楼为最佳答案
本帖最后由 gufengaoyue 于 2015-7-24 19:22 编辑
哦,没注意看到是2个表,改下就好了。
- Sub 排序()
- Dim arr, i&, Sht As Worksheet
- For Each Sht In Sheets
- Sht.Activate
- For i = 1 To Cells(2, "iv").End(xlToLeft).Column Step 2
- arr = Range(Cells(3, i), Cells(Rows.Count, i + 1).End(3))
- BubbleSort2 arr
- Range(Cells(3, i), Cells(Rows.Count, i + 1).End(3)) = arr
- Next
- Next
- End Sub
- Sub BubbleSort2(ByRef arr)
- Dim i&, j&, vSwap1, vSwap2
- For i = UBound(arr) To 2 Step -1
- For j = 1 To i - 1
- If arr(j, 2) < arr(j + 1, 2) Then
- vSwap1 = arr(j, 1)
- vSwap2 = arr(j, 2)
- arr(j, 1) = arr(j + 1, 1)
- arr(j, 2) = arr(j + 1, 2)
- arr(j + 1, 1) = vSwap1
- arr(j + 1, 2) = vSwap2
- End If
- Next
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|