Keep display steady while macro runs

[Salman]

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

 

[Jase]

application.screenupdating = false

 

[Biff]

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

 

[D.S.]

You didn't say which version you are running.

Have your code select the tab of your preference, then turn off screen
refreshing until macro is finished, the last line before <end sub> turn
"screenrefreshing" back on.

Depending on which version you are running, it may be called screen
updating.

application.screenupdating=false
application.screenupdating=true


d.s.
Donald (e-mail address removed)