Screen Update

[BP]

Good morning,
Can you refresh me on the code that stop the screen from showing everything
that's happening in the macro? For instance, as cells are being selected
and updated via the macro, don't actually show this on the screen.

Thanks in advance.

 

[Frank Kabel]

Hi
Application.ScreenUpdating = False / True
you may also consider using
Application.Calculation = xlCalculationManual / xlCalculationAutomatic
So in total:
-----
Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic
end sub