screen updating

[Josie]

Sorry to ask all you smart people such a dumbass question
but at least it'll be easy to answer.

What's the command that stops all the actions your macro
is performing from happening 'live' on the screen? Instead
all you see is the start point and endpoint, and it really
speeds things up.

I'm in a bit of a VB desert here, so I'd be grateful for
help.

 

[SeanEvans]

To turn screen updating off -

Application.ScreenUpdating = False

and to turn it back on -

Application.ScreenUpdating = True.

Enjoy

 

[josie]

thanks Sean

 

[Bob Phillips]

Application.ScreenUpdating = False

.... do your stuf

Application.ScreenUpdating = True

 

[Josie]

thanks Bob, there's another one for ya...