处理大数据量时,为了更快的运行,VBA通常在开始加两句
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
结尾处再恢复
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
calculation是指手动计算还是自动计算。
转载于:https://www.cnblogs.com/lotussoft/archive/2010/05/12/1733808.html