Thanks for your replies.
I will see how it goes.
I did originally record the macro but it was no use, it didnt like the
way the macro set properties.
Thanks again for your help.
Shane
--
Shane B
------------------------------------------------------------------------
Shane B's Profile:
http://www.excelforum.com/member.php...o&userid=16467
View this thread:
http://www.excelforum.com/showthread...hreadid=278207