Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
Shorten a Macro | Excel Discussion (Misc queries) | |||
Inconsistent Macro Behavior | Excel Discussion (Misc queries) | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |