Running Macros in Excel 2003

[Guest]

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?

 

[Guest]

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

 

[Guest]

With Norton, all things are possible...

Without knowing what your macro is doing, it's difficult to say what the
cause may be. But since it is (apparently) just the one macro, I suspect
it's the macro itself rather than your security software. Either tell us in
plain words what the macro does, or better yet, post the code here.

In the meantime, the suggestions made by Barb are good ones - I've seen
macros that placed data onto worksheets improve performance by as much as a
factor of 10 just by using the Application.ScreenUpdating = False feature.
And if what ever your macro is doing affects other functions that have to be
recalculated based on what your macro is placing on the sheets, turning the
Calculate of during the process can help - then it will just recalculate
everything at the end of the process.

 

[Guest]

Thanks Barb. I'll give it a try.

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