Workbook Slow

[Karen53]

Hi,

I find my program execution is quite slow and I suspect it is because of the
Worksheet_Calculate routine. Is there a way to have Worksheet_calculate
programatically run only once instead of once for every change that was made?
Also, have it run only on the sheet the change impacted?

I already have Application.Screenupdating set to false and
Application.EnableEvents set to false

 

[GKeramidas]

put these at the beginning of your code:
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

and these at the end
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

 

[Karen53]

Oh, wow! I can't get over the difference that made! Now it's 'smokin'
Thank you Gary!!
--
Thanks for your help.
Karen53

put these at the beginning of your code:
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

and these at the end
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic