|
xhuang 发表于 2014-11-19 11:14
非常感谢,结果可以出来,
但有一点小问题,还需再帮忙一下,如下 - Sub demo()
- Dim ar, br(1 To 60000, 1 To 22)
- For x = 2 To Sheets.Count
- If Sheets(x).Name <> "Summary" Then
- m = Sheets(x).Cells(Rows.Count, 1).End(3).Row
- If m > 4 Then
- ar = Sheets(x).Range("A4:V" & m)
- For i = 1 To UBound(ar)
- n = n + 1
- For j = 1 To UBound(ar, 2)
- br(n, j) = ar(i, j)
- Next
- Next
- End If
- End If
- Next
- Sheet1.Columns("d:e").NumberFormatLocal = "@"
- Sheet1.Range("d6").Resize(n, 22) = br
- End Sub
复制代码 |
评分
-
查看全部评分
|