Depending what your code is up to sometimes turning calcualtions off wile the
macro is running will speed things up. As with any application level events
it is best to include an error handler when you modify these settings
(Calculation, Alerts, Events)...

Sub DoYourStuff()
on error goto errorhandler
application.calculation = xlManual
applicaton.enableevents = false
'Your code here

ErrorHandler:
application.calculation = xlAutomatic
applicaton.enableevents = true
End Sub

--
HTH...

Jim Thomlinson


"tcgaines" wrote:


perfect!!! i dont know why its soooo slow (about 3-4 minutes) but it
works!!


--
tcgaines
------------------------------------------------------------------------
tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608
View this thread: http://www.excelforum.com/showthread...hreadid=493857