|
发表于 2013-1-19 22:51
|
显示全部楼层
本楼为最佳答案
- Sub 效果一()
- Dim arr
- arr = ActiveSheet.UsedRange
- Dim i&, str$, str2, j&
- For i = 1 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- str = str & arr(i, j)
- arr(i, j) = ""
- Next
- arr(i, 2) = str
- str = ""
- Next
- ActiveSheet.UsedRange.Offset(UBound(arr) + 1) = arr
-
- End Sub
- Sub 效果二()
- Dim arr
- arr = ActiveSheet.UsedRange
- Dim i&, str$, str2, j&, k&
- For i = 1 To UBound(arr)
- k = 1
- For j = 2 To UBound(arr, 2)
- If Len(arr(i, j)) > 0 Then
- k = k + 1
- If k <> j Then
- arr(i, k) = arr(i, j)
- arr(i, j) = ""
- End If
- End If
- Next
- k = 1
- Next
- ActiveSheet.UsedRange.Offset(UBound(arr) + 1) = arr
- End Sub
复制代码 隔行输出整理后的数据 |
评分
-
查看全部评分
|