As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.
1. At the beginning of your code put this line:
Application.ScreenUpdating = False
2. At the end of your code put this line:
Application.ScreenUpdating = True
Hey, thanks for easy & simple explanation. I had a problem with data import and graph updating after every single record…
Very well written article, thx for sharing.
Thanks! Great solution, especially when using a recorded macro in combination with RDP/Terminal Server/Citrix on a slow connection!