I have 3 worksheets. Each worksheet has 44,000 cells with formulas in them.
Altogether that comes out to 132,000 cells with formulas.

I added a long macro to the workbook which works mostly with another
worksheet. When I run the macro it takes a ridiculously long time to
complete the steps. The reason it takes so long is because of the 132,000
cells with formulas. When I remove those 3 worksheets, its works fine.

Is there a way I can speed up the macro without getting rid of the 3
worksheets I mentioned or purchasing extra memory for my computer?

It may help if we could SEE your code.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TGalin" wrote in message
...
I have 3 worksheets. Each worksheet has 44,000 cells with formulas in
them.
Altogether that comes out to 132,000 cells with formulas.

I added a long macro to the workbook which works mostly with another
worksheet. When I run the macro it takes a ridiculously long time to
complete the steps. The reason it takes so long is because of the 132,000
cells with formulas. When I remove those 3 worksheets, its works fine.

Is there a way I can speed up the macro without getting rid of the 3
worksheets I mentioned or purchasing extra memory for my computer?

Hi,

Try

Application.Calculation = xlManual
Application.ScreenUpdating = False
'your code
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

Mike


"TGalin" wrote:

I have 3 worksheets. Each worksheet has 44,000 cells with formulas in them.
Altogether that comes out to 132,000 cells with formulas.

I added a long macro to the workbook which works mostly with another
worksheet. When I run the macro it takes a ridiculously long time to
complete the steps. The reason it takes so long is because of the 132,000
cells with formulas. When I remove those 3 worksheets, its works fine.

Is there a way I can speed up the macro without getting rid of the 3
worksheets I mentioned or purchasing extra memory for my computer?

This is better than perfect. Thank you very much. Precisely what I was
aiming to do. Thank you!

"Mike H" wrote:

Hi,

Try

Application.Calculation = xlManual
Application.ScreenUpdating = False
'your code
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

Mike


"TGalin" wrote:

I have 3 worksheets. Each worksheet has 44,000 cells with formulas in them.
Altogether that comes out to 132,000 cells with formulas.

I added a long macro to the workbook which works mostly with another
worksheet. When I run the macro it takes a ridiculously long time to
complete the steps. The reason it takes so long is because of the 132,000
cells with formulas. When I remove those 3 worksheets, its works fine.

Is there a way I can speed up the macro without getting rid of the 3
worksheets I mentioned or purchasing extra memory for my computer?