MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SLOW calulation of cells

Posted by QQMark on February 14, 2001 12:00 PM

I just increased my RAM to 256K and it still takes 3 to 20 minutes to calculate cells during execution of a macro. How come? What can I do to speed the process up?

Posted by Faster on February 14, 2001 5:21 PM

'maybe add

Application.ScreenUpdating = False

'as the first line of your code

Posted by Dave Hawley on February 15, 2001 2:27 AM

Hi Mark

In addition to turning off Screenupdating try;

Application.Calculation = xlCalculationManual
'Your Code
Application.Calculation = xlCalculationAutomatic

You need to turn screenupdaing back on.


OzGrid Business Applications