Supress screen update while writiing to another sheet
 

Hi
I am trying to copy data to Sheet2 from Sheet1 without the user seeing the
screen change.
What code sould I use?
Regards
Scooper

Supress screen update while writiing to another sheet
 

hi Scooper

Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = true

See this page for example code
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"scooper" wrote in message u...
Hi
I am trying to copy data to Sheet2 from Sheet1 without the user seeing the
screen change.
What code sould I use?
Regards
Scooper

Supress screen update while writiing to another sheet
 

Hi scooper,

Use ...

Application.ScreenUpdating = False

.... at the Beginning, and ...

Application.ScreenUpdating = True

.... at the End ( Before the End Sub ).

Hope this Helps.
All the Best.
Paul

scooper wrote:
Hi
I am trying to copy data to Sheet2 from Sheet1 without the user seeing the
screen change.
What code sould I use?
Regards
Scooper