VBA – Turn off Screen Updating
As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.
Disable Screen Updating
1. At the beginning of your code put this line:
Application.ScreenUpdating = False
Enable Screen Updating
2. At the end of your code put this line:
Application.ScreenUpdating = True
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Did you find this VBA tutorial useful? Then share it with your friends and colleagues: