Macros Execute slowly

[Rene''48]

Hello Tech Support

I am developing macros in Excel 2003.

I have a main macro that has 7 other sub macros. The first time I run the
macro it executes very fast. If I run the macro again it executes slowly.
As suggested added the command Application.ScreenUpdating = False at the
beginning of my macro and Application.ScreenUpdating = True at the end of my
macro. When I ran the macro again it still does not execute as fast as it
did the first time. However the Application.ScreenUpdating does make it run
faster but not as fast as it ran the first time I executed the same macro. I
had to close excel and open the file again to make the macro execute fast. As
a test I made copies of the file and opened one at a time. What I found was
if I opened the copied file for the first time the macro executed very fast.
Does Excel remember all the macros that were executed in the file while the
file is still open? I believe all procedures are saved somewhere in Excels
memory making the larger macro execute more slowly. If this is true is there
a command that would wipe out the memory in excel so my macro could execute
quickly?

If what I am saying sounds confusing is there a number I could call and talk
someone?

Thank you for your help.

Rene’

 

[Gary Keramidas]

don't know what you're doing in your macros, but you can try turning
calculation off, too.

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

and then back on at the end
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic