How to stop screen blinking when running macro
 

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

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