I've had macros speed up considerably when I've turned screen updating

Application.ScreenUpdating = FALSE 'at beginning
Application.ScreenUPdating = TRUE 'at end

and turned off calculations

Worksheets("Sheet1").EnableCalculation = FALSE ' at beginning
Worksheets("Sheet1").EnableCalculation = TRUE ' at end

HTH,
Barb Reinhardt

"mickey" wrote:

When I am running a particular macro in Excel 2003 my PC boggs down terribly.
The PC usage spikes up to 75% or more and it takes a very long time to run.
It appears to be a spooling issue.

Has anyone encountered this? Any suggestions? Could this be a Norton's issues?