|
发表于 2014-10-19 19:33
|
显示全部楼层
本楼为最佳答案
KDZ 发表于 2014-10-19 19:18
请问怎么搞法? - Sub demo()
- Dim arr, temp, x, y, t, k, i, a
- a = Sheet1.Cells(Rows.Count, 2).End(xlUp).Row
- arr = Range("a2:b" & a)
- For x = 1 To UBound(arr) - 1
- For y = x + 1 To UBound(arr)
- For i = 1 To 2
- If Len(arr(x, 2)) < Len(arr(y, 2)) Then
- temp = arr(x, i)
- arr(x, i) = arr(y, i)
- arr(y, i) = temp
- End If
- Next
- Next
- Next
- Range("d2").Resize(x, 2) = ""
- Range("d2").Resize(x, 2) = arr
- End Sub
复制代码
Book1.rar
(10.01 KB, 下载次数: 18)
|
|