Here’s the tip.
Turn off screen updating.
Doing this is like jumping to the desired movie scene instead of watching a chain of quick-motion sequences before you watch it.
When you do this, your macro will not spend computing resources to update the screen at every action it performs.
- Shifting sheets (this does not occur if you implement tip 2 mentioned above)
- Range selections (this does not occur if you implement tip 2 mentioned above)
- Chart creation
- Table creation
- and other outputs
How do you do that?
It’s very simple…
Write this instruction at the beginning of your macro (after the “Public Sub ()” line)…
“Application.ScreenUpdating = False” (without quotation marks)
And this one at the end of your macro (before the “End Sub” line)…
“Application.ScreenUpdating = True” (without quotation marks)