Thanks for your reply. I remember that there is a menu option somewhere
in Excel that performs that function for you instead of having to use
VBA or macros etc. Does anyone know if that is the case or not? I'm
not too sure how to use macros and VBA.

Thanks.


--
craig72
------------------------------------------------------------------------
craig72's Profile: http://www.excelforum.com/member.php...o&userid=35540
View this thread: http://www.excelforum.com/showthread...hreadid=553034