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.Screenupadting=False
Application.Calculation = xlCalculationManual
'Your Code
Application.Calculation = xlCalculationAutomatic
Application.Screenupadting=True


You need to turn screenupdaing back on.


Dave


OzGrid Business Applications