Well you could record a macro and run that macro as necessary.

Not sure how familiar you are with those, though.

"alex1982" wrote:


I have tried that before, was just wondering if there was another way of
doing it.


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=572589