Screen gets jumpy while macro executes

  • Thread starter Thread starter Kevlar
  • Start date Start date
K

Kevlar

Is there a way to keep the screen from jumping while your macr
executes
 
Hi
add the line
application.ScreenUpdating = False
at the beginning of your macro

and the line
application.ScreenUpdating = True
at the end
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically executing macros 1
Excel On Error Resume Next 2
Excel TWO Instances of Excel One watching Other 3
Protected sheets and running macros 1
Macro Debug 5
Display a message when a macro is executing 2
Mouse priority 5
Just in case there is a cure for "jumping rows"... 3

Back
Top