Screen Updating using VBA in Excel

When you don't want to see your screen follow the actions of your VBA code (macro), you can use ScreenUpdating property:


Use ScreenUpdating property to turn screen updating off to speed up your macro code:

Application.ScreenUpdating = False

You won't be able to see what the macro is doing, but it will run faster. When your macro ends don't forget to set the ScreenUpdating property back to True.

Application.ScreenUpdating = True


'  Add New Worksheet
Private Sub GenerateNewWorksheet()
    Dim ActSheet As Worksheet
    Dim NewSheet As Worksheet
    ' Prevents screen refreshing.
    Application.ScreenUpdating = False

    Set ActSheet = ActiveSheet
    Set NewSheet = ThisWorkbook.Sheets().Add()
    NewSheet.Move After:=Sheets(ThisWorkbook.Sheets().Count)

     ' Enables screen refreshing.
    Application.ScreenUpdating = True
End Sub


comments powered by Disqus