|
发表于 2012-8-21 22:55
|
显示全部楼层
本楼为最佳答案
- Sub CombineSheet()
- Dim arr, shtCount%, i&, t
- shtCount = Sheets.Count
- Application.ScreenUpdating = False
- t = Timer
- Sheets(1).Cells.ClearContents
- For i = 2 To shtCount
- With Sheets(i)
- arr = .Range(.Range("a7"), .Cells(.UsedRange.Rows.Count, .UsedRange.Columns.Count))
- End With
- Sheet1.Range("a" & Cells.Rows.Count).End(3).Offset(1, 0).Resize(UBound(arr), UBound(arr, 2)) = arr
- Next
- Application.ScreenUpdating = True
- MsgBox Timer - t
- End Sub
复制代码 测试了300多张工作表,用时大约10秒 |
|