Disable screen refresh during long macro execution

  • Thread starter Thread starter John Leavy
  • Start date Start date
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.
 
John

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

Regards

Trevor
 
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
 
Back
Top