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

.