Microsoft Office

Top Ten Tips To Speed Up Your VBA Code

1. Turn off Screen Updating This will stop the screen flickering and updating while executing or running macros, and that will greatly speed up your code. Sub Stop_ScreenUpdating () Application.ScreenUpdating = False ‘… (Your Code) Application.ScreenUpdating = True End Sub Tip: Use Application.ScreenUpdating = False at the beginning of your code and Application.ScreenUpdating = True[…]