How to stop screen blinking when running macro
Try screenupdating = False / True, like:
Sub Test
Application.ScreenUpdating = False
Sheet2.Activate
Sheet2.Range ("A1").Select
Sheet1.Activate
Sheet1.Range ("A1").Select
Application.ScreenUpdating = True
End Sub
/Regards Nobody
"Stephen" skrev i meddelandet
...
Hi,
I have prepared a macro that needs to access 2 different workbooks.
However, when I run the macro, the screen blinkx until the macro finished
running. Is there any way I can stop the screen blinking?
Thanks in advance.
-- Stephen
|