Sub 汇总()
Application.ScreenUpdating = False '关闭屏幕刷新,提高运行速度
For Each sht In Sheets '所有的工作表中循环
If Not sht.Name = "汇总" Then
'......
'......
End If
Next sht
Application.ScreenUpdating = True
End Sub
Sub 汇总()
Application.ScreenUpdating = False '关闭屏幕刷新,提高运行速度
For Each sht In Sheets '所有的工作表中循环
If Not sht.Name = "汇总" Then
'......
'......
End If
Next sht
Application.ScreenUpdating = True
End Sub