screen updating
 

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.

screen updating
 

To turn screen updating off -

Application.ScreenUpdating = False

and to turn it back on -

Application.ScreenUpdating = True.

Enjoy

--
SeanEvan
-----------------------------------------------------------------------
SeanEvans's Profile: http://www.excelforum.com/member.php...fo&userid=1465
View this thread: http://www.excelforum.com/showthread.php?threadid=26458

screen updating
 

thanks Sean
-----Original Message-----

To turn screen updating off -

Application.ScreenUpdating = False

and to turn it back on -

Application.ScreenUpdating = True.

Enjoy !


--
SeanEvans
----------------------------------------------------------
--------------
SeanEvans's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14650
View this thread:
http://www.excelforum.com/showthread...hreadid=264583

.

screen updating
 

Application.ScreenUpdating = False

.... do your stuf

Application.ScreenUpdating = True

--

HTH

RP

"Josie" wrote in message
...
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.

screen updating
 

thanks Bob, there's another one for ya...
-----Original Message-----

To turn screen updating off -

Application.ScreenUpdating = False

and to turn it back on -

Application.ScreenUpdating = True.

Enjoy !


--
SeanEvans
----------------------------------------------------------
--------------
SeanEvans's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14650
View this thread:
http://www.excelforum.com/showthread...hreadid=264583

.