Sub 全年工资汇总() Application.ScreenUpdating = False Dim x As Long, y As Long, i As Long, j As Long, sht As Worksheet Dim arr1 Dim arr2(1 To 228, 1 To 34) For Each sht In Worksheets If sht.Name Like "*月" Then arr1 = sht.Range("C3:AJ230") For x = 1 To 228 For y = 1 To 34 arr2(x, y) = arr2(x, y) + arr1(x, y) Next y Next x End If Next Sheet6.Range("C3").Resize(228, 34) = arr2 Application.ScreenUpdating = True End Sub
Sub 全年工资汇总() Application.ScreenUpdating = False Dim x As Long, y As Long, i As Long, j As Long, sht As Worksheet Dim arr1 Dim arr2(1 To 228, 1 To 34) For Each sht In Worksheets If sht.Name Like "*月" Then arr1 = sht.Range("C3:AJ230") For x = 1 To 228 For y = 1 To 34 arr2(x, y) = arr2(x, y) + arr1(x, y) Next y Next x End If Next Sheet6.Range("C3").Resize(228, 34) = arr2 Application.ScreenUpdating = True End Sub