Workbook Slow
 

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

--
Thanks for your help.
Karen53

Workbook Slow
 

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
--

Gary


"Karen53" wrote in message
...
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

--
Thanks for your help.
Karen53

Workbook Slow
 

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


"GKeramidas" wrote:

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
--

Gary


"Karen53" wrote in message
...
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

--
Thanks for your help.
Karen53