View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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
.

.