Maybe if you also disable the events it is faster

Before the loop
Application.EnableEvents = False


and after the code is ready
Application.EnableEvents = True


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tcgaines" wrote in message
...

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