slow performance

J

Jim

Similar problem and I was directed to this site
http://www.mvps.org/dmcritchie/excel/slowresp.htm
that gave me the following information:


Turn off calculation and screen refresh while macro is
running. Be sure to restore settings when the macro
ends. Some supposedly reset automatically but later
releases tend to require you to reset. Macros may
terminate abnormally so don't use without that thought in
mind. The examples below do not save current settings
and restore them but assume normal usage is in effect.
Turning off ScreenUpdating and Calculation are the
easiest changes to implement.

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
' ooo Your code here ooo
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
 
Top