|
本帖最后由 dsmch 于 2017-2-22 17:24 编辑
Sub Macro1()
Dim arr, brr, i&, j%
arr = Range("a1").CurrentRegion
ReDim brr(1 To UBound(arr, 2), 1 To 1)
For j = 1 To UBound(arr, 2)
p = ""
For i = 1 To UBound(arr)
p = p & "-" & arr(i, j)
Next
brr(j, 1) = Mid(p, 2)
Next
Range("e1").Resize(UBound(brr)) = brr
End Sub
Sub Macro2()
Dim arr, brr, j%
arr = Range("a1").CurrentRegion
ReDim brr(1 To UBound(arr, 2), 1 To 1)
For j = 1 To UBound(arr, 2)
brr(j, 1) = Join(Application.Transpose(Application.Index(arr, 0, j)), "-")
Next
Range("e1").Resize(UBound(brr)) = brr
End Sub
|
评分
-
查看全部评分
|