How to set Application.ScreenUpdating = False for Gen use

[David_Williams_PG ()]

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.

[Bob Phillips]

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 ()@discussions.microsoft.com> wrote
in message news:[email protected]...
> 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.