View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.