echo off?

[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

 

[Chip Pearson]

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)