|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
网上找了各种代码尝试了两天两夜了,还是错误。帮忙看看修改一下,有偿!Sub 合并工作表333636()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Sheets(1).Select
Sheets.Add
Sheets(1).Name = "汇总表"
Dim i, j, k As Integer
For k = 2 To Sheets.Count
j = Sheets("汇总表").[a1048576].End(3).Row + 1
Sheets(k).Select
i = Sheets(k).[a1048576].End(3).Row
Sheets(k).Rows("1" & ":" & i).Copy Sheets("汇总表").Cells(j, 1)
Next
Sheets(1).Select
Rows(1).Delete
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
|
|