Thanks for that. However it doesnt work. Not sure whether teh fact taht
I am on a Mac has affected it? The formatting doesnt change at all.

Any other solutions?


--
Number_8
------------------------------------------------------------------------
Number_8's Profile: http://www.excelforum.com/member.php...fo&userid=6590
View this thread: http://www.excelforum.com/showthread...hreadid=375666