echo off?

  • Thread starter Thread starter Lee S.
  • Start date Start date
L

Lee S.

In a macro, I have a loop to copy rows from a workbook and
paste it to another workbook, so there are a lot
of "flashing" between screens in the run. Someone said if
I can use some kind of "echo off" command to aviod
flashing screens, it would cut down the run time a lot.
Is there such command that I can use in EXCEL macro??

Thanks.

Lee
 
Lee,

Use the ScreenUpdating property to prevent the screen from updating. E.g.,

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top