where it says 'Range("Z4:Z9").Select' in the macro it needs somethin
that tells it to select the cells to the right? So it formats the cell
in the inserted columns.

Am I along the right lines

--
mevett

-----------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...fo&userid=2913
View this thread: http://www.excelforum.com/showthread.php?threadid=48879