Can I keep the screen from jumping when running a macro?
 

I'm running a macro that is cutting and pasting and selecting cells
from all over my spreadsheet. When it is running, my screen is jumping
all over so quickly that i cannot see anything.

Is it possible to make the screen stay put?

TIA,
JasonK

Can I keep the screen from jumping when running a macro?
 

Try this:
Application.ScreenUpdating = False
your code
Application.ScreenUpdating = true

Can I keep the screen from jumping when running a macro?
 

worked perfectly.

thanks a ton.
jasonk




On 18 Mar 2006 23:52:46 -0800, "ward376"
wrote:

Try this:
Application.ScreenUpdating = False
your code
Application.ScreenUpdating = true