How stop display of worksheets during macro
 

I have a macro that copies a bunch of data between worksheets. It would run a
lot faster if I could tell excel to stop displaying worksheets. How do I turn
this fcn off and back on again?

How stop display of worksheets during macro
 

Hi John

Application.ScreenUpdating = False
...
do your stuff
...
Application.ScreenUpdating = True

--
Regards

Roger Govier


"John" wrote in message
...
I have a macro that copies a bunch of data between worksheets. It would
run a
lot faster if I could tell excel to stop displaying worksheets. How do
I turn
this fcn off and back on again?