MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Problem: Flashing Screen.


Posted by Uttam on July 05, 2001 1:31 PM

Hello,

One of the macros I execute, opens two files, copies values from one to the other. My macro changes focus from one file to the other, copies, then "pastes special" Values into the first.

In all this switching back and forth from the first to the second to the first and back, the screen just displays each file for a moment and the screen seems to flash.

Is there someway I can stop this flashing?

Thanks in advance


Posted by faster on July 05, 2001 1:38 PM

place this at the start of your code
Application.ScreenUpdating = False
'then make sure you turn screenupdating back on
'place this at the end of your code
Application.ScreenUpdating = True

Posted by Uttam on July 05, 2001 2:21 PM

Works perfectly!

Thanks a lot!

Uttam