Keep display steady while macro runs
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
.
|