ExcelBanter - Excel Suspend / Resume Layout

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel Suspend / Resume Layout (https://www.excelbanter.com/excel-programming/392328-excel-suspend-resume-layout.html)

Peter

Excel Suspend / Resume Layout

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.

Tim

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.

All times are GMT +1. The time now is 09:45 PM.