|
发表于 2015-12-13 21:42
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, i&, s&, j%, k%
- Sheets("数据").Activate
- arr = ActiveSheet.UsedRange
- ReDim brr(1 To 60000, 1 To 6)
- For i = 1 To UBound(arr)
- For j = 6 To UBound(arr, 2)
- If arr(i, j) <> "" Then
- s = s + 1
- brr(s, 6) = arr(i, j)
- For k = 1 To 5
- brr(s, k) = arr(i, k)
- Next
- End If
- Next
- Next
- Sheet2.Range("a1").Resize(s, 6) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|