Macros Execute Very Slow Problem
 

Hello Tech Support,

I am writing a macro in excel 2003:
I have written a macro that uses 7 other macros. My problem is if I execute
the macro again the macro executes very slowly. I find I have to close excel
and open the excel file again so that it will not execute slowly. Is this
taking up a lot of memory? Are there any macro codes that will solve this
problem without having to close the excel file?

Thank you for your help.

Rene'

Macros Execute Very Slow Problem
 

Hello Tech Support,

Hi,

This isn't tech support, it's a community in which people give their time
freely to help others.

Without seeing your macros it's hard to be specific but a good start is


sub macro1()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

'call your macros

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
end sub

Mike
"Rene''48" wrote:

Hello Tech Support,

I am writing a macro in excel 2003:
I have written a macro that uses 7 other macros. My problem is if I execute
the macro again the macro executes very slowly. I find I have to close excel
and open the excel file again so that it will not execute slowly. Is this
taking up a lot of memory? Are there any macro codes that will solve this
problem without having to close the excel file?

Thank you for your help.

Rene'