|
发表于 2017-1-19 11:23
|
显示全部楼层
本楼为最佳答案
- Sub 汇总()
- Dim sht As Worksheet, i&, arr
- For Each sht In Sheets
- If sht.Name <> "汇总" Then
- arr = sht.UsedRange.Offset(1, 0)
- Sheets("汇总").Cells(Rows.Count, 1).End(3). _
- Offset(1, 0).Resize(UBound(arr), UBound(arr, 2)) = arr
- End If
- Next
- End Sub
复制代码 |
|