Janjko

In one macro I delete a lot of rows. Each time a row is deleted, the grid draws again and it slows down the process. How do I suspend drawing of the grid until the job is done




Re: Visual Studio Tools for Office Suspending layout in excel

Geoff Darst - MSFT

Hi,

The ScreenUpdating property is what you are looking for. Application.ScreenUpdating=False will turn off screen updates and speed up the process for you.

Sincerely,

Geoff Darst

Microsoft VSTO Team





Re: Visual Studio Tools for Office Suspending layout in excel

Janjko

Thanks, that's it!