View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 145
Default Excel Suspend / Resume Layout

xlApp.screenupdating=False
....
xlApp.screenupdating=True

Tim

"Peter" wrote in message
...
I am populating an Excel spreadsheet from C#. I want to suspend layout
(re-drawing) of Excel while the spreadsheet is being populated, and then
resume layout when completed. How is this done.