Application.ScreenUpdating&Application.Calculation

处理大数据量时，为了更快的运行，VBA通常在开始加两句
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
结尾处再恢复
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
calculation是指手动计算还是自动计算。