也不知怎么就被我给弄出来了,数组多写锻炼脑子。不过以下代码可以用就是了,请看下吧
Sub ds90()
Dim arr, k%
k = Cells(Cells.Rows.Count, "f").End(xlUp).Row
ReDim arr(1 To k)
For i = 1 To k
arr = Range("a" & i, "f" & i)
ar = Application.Transpose(Application.Transpose(arr))
Cells(i, "i") = Join(ar, ",")
Next
End Sub
Sub ds901()
Dim arr, k%
k = Cells(Cells.Rows.Count, "f").End(xlUp).Row
ReDim arr(1 To k)
For i = 1 To k
arr = Range("a" & i, "f" & i)
ar = Application.Transpose(Application.Transpose(arr))
Cells(i, "i") = Join(ar, ",") & ","
Next
End Sub