Keep display steady while macro runs
Don't forget to restore that at the end of the macro:
Sub YourMacro()
Application.ScreenUpdating = False
Your code goes here
Application.ScreenUpdating = True
End Sub
Biff
-----Original Message-----
application.screenupdating = false
-----Original Message-----
Hi. I have a simple macro that cuts and pastes values
from
different tabs to an output tab. Sample code is:
Sheets("addressing").Select
Range("svcstack").Select
Selection.Copy
Sheets("Output driver page").Select
Range("cell1").Select
Selection.PasteSpecial Paste:=xlValues
Problem is that while the code runs, each tab selected
is
displayed. I would like to keep the output tab, call
it "output", displayed as the macro runs. Please help.
Thanks
.
.
|