View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Salman[_2_] Salman[_2_] is offline
external usenet poster
 
Posts: 4
Default Keep display steady while macro runs

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