View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default Turning off display while VBA running

Application.Screenupdating

Tim

"Bob Bridges" wrote in message
...
Seems to me I once saw an option I can turn off to keep Excel from
updating
the display while my program inserts rows, fills in data, hides/unhides
rows
and such, so it'll run faster if there's a lot to be accomplished...the
idea
being that the program will turn the display, so to speak, back on just
before it gets to End Sub. Now I want to use that feature and I can't
find
it in my VBA/Excel chm. Can anyone tell me where to look for it? Thanks.