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.
|