Quick tip to make your recorded Excel macros super fast

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)