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

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" <robertc47@optusnet.com.au> wrote in message news:434ab0ad$0$22589$afc38c87@news.optusnet.com.au...
> 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
>
>

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