Works a charm thanks guys.

What i had done was use range.select then hide column. For some reaso
it didn't like this.

THanks again,

Chri

--
chris10
-----------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...fo&userid=2516
View this thread: http://www.excelforum.com/showthread.php?threadid=53657