Screenupdating

[Geoff]

When using vba and adding numerous formulas to the worksheet the screen
shudders when each calculation is inserted. The VBA has

1. Screenupdating turned off
2. Calculation turned to manul
3. No Excel events that are triggering.

Does anyone have any idea as to any other reasons?

Thanks for your consideration.

 

[David McRitchie]

Hi Geoff,
Are the macros calling other macros that are also turning off screen refresh
and calculation and turn them back on. If so you could have
them turned on for most of the macro.

Are you switching worksheets, inserting/deleting worksheets,
printing or turning protection on or off. Opening and closing
a workbook, saving workbook or anything you can think of
that is unusual.