Sub 月度汇总()
Dim arr
Application.DisplayAlerts = False
For i = 1 To Sheets.Count
Worksheets(i).Unprotect
arr = Worksheets(i).Range("a1:z" & Cells(Rows.Count, 3).End(xlUp).Row)
Worksheets(i).Range("a1").Resize(UBound(arr), UBound(arr, 2)) = arr
Next
ThisWorkbook.SaveAs "d:\乙.xls"
Application.DisplayAlerts = True
End Sub
Sub 月度汇总()
Dim arr
Application.DisplayAlerts = False
For i = 1 To Sheets.Count
Worksheets(i).Unprotect
arr = Worksheets(i).Range("a1:z" & Cells(Rows.Count, 3).End(xlUp).Row)
Worksheets(i).Range("a1").Resize(UBound(arr), UBound(arr, 2)) = arr
Next
ThisWorkbook.SaveAs "d:\乙.xls"
Application.DisplayAlerts = True
End Sub