How to set Application.ScreenUpdating = False for Gen use
 

Am trying to delete rows out of a spreadsheet (Excel 2003) and it is taking
for ever to remove. There must be a default setting were I can set
Application.ScreenUpdating = False

Does anyone know how to set Excel update to speed up the removal of rows.
Any help greatly appreciated,
David.

How to set Application.ScreenUpdating = False for Gen use
 

No default setting, but really, how much effort is it to include it where
needed?

You might also consider turning automatic calculation off, and reset at the
end.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David_Williams_PG" <David_Williams_PG wrote
in message ...
Am trying to delete rows out of a spreadsheet (Excel 2003) and it is
taking
for ever to remove. There must be a default setting were I can set
Application.ScreenUpdating = False

Does anyone know how to set Excel update to speed up the removal of rows.
Any help greatly appreciated,
David.