|
这样行不:
Sub test()
Dim ar()
i% = [a65536].End(3).Row
Range("B2").Resize(i - 1, 1).TextToColumns Destination:=Cells(i + 10, 2), OtherChar:=","
c% = Cells(i + 10, 2).CurrentRegion.Columns.Count
Do While Cells(i + 10, 2) <> ""
Cells(i + 10, 2).Resize(1, c).Sort Cells(i + 10, 2), , , , , , , xlGuess, , , xlSortRows
i = i + 1
Loop
ar = Cells(i + 10, 2).CurrentRegion.Value
Cells(i + 10, 2).CurrentRegion.Clear
For i = 1 To UBound(ar)
For c = 2 To UBound(ar, 2)
If ar(i, c) = "" Then Exit For
ar(i, 1) = ar(i, 1) & "," & ar(i, c)
Next
Next
[d2].Resize(UBound(ar), 1) = ar
End Sub |
评分
-
查看全部评分
|