Stop automatic updates - Speed

[wwj]

Stop automatic updates - Speed
- Stop the automatic updating processing while coping data in cells

Code: Select all

    ' To speed up the macro.
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    Application.Calculation = xlManual

.....

    ' Activate the auto update!
    Application.Calculation = xlAutomatic
    Application.ScreenUpdating = True
    Application.EnableEvents = True