Disable screen refresh during long macro execution

J

John Leavy

I have an exceedingly long macro which runs for approx 15
minutes doing extensive lookups and cell updates (1000's).
Can I disable the screen refresh during execution, im sure
it would speed up execution tenfold & be easier on the
eyes.
 
T

Trevor Shuttleworth

John

Application.ScreenUpdating = False
Application.Calculation = xlManual
' your code
Application.Calculation = xlAutomatic
Application.ScreenUpdating = True

Regards

Trevor
 
J

JulieD

Hi John

at the top of the macro put the line
application.screenupdating = false

and at the end
application.screenupdating = true

not sure if this will do anything to the speed but should stop the screen
flashing :)
ps have you changed the cursor to an hourglass or something so that people
know the macro is running

Cheers
JulieD
 

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

Top