|
发表于 2013-12-31 16:05
|
显示全部楼层
本楼为最佳答案
- Sub 排序()
- Dim arr, brr, br, tmp, i&, j%, k%
- arr = Range("B1:B" & Cells(Rows.Count, 2).End(3).Row).Value
- For i = 1 To UBound(arr)
- brr = Split(arr(i, 1), " ")
- For j = 0 To UBound(brr) - 1
- For k = 0 To UBound(brr) - 1
- If brr(k) > brr(k + 1) Then
- tmp = brr(k)
- brr(k) = brr(k + 1)
- brr(k + 1) = tmp
- End If
- Next
- Next
- arr(i, 1) = Join(brr)
- Next
- Range("B1:B" & UBound(arr)) = arr
- End Sub
复制代码 |
|