Easiest way I know is to Copy the column headings, highlight the cell
you want to be the start of your new column with the headings in, and
go to Copy Paste Special and check the Transpose box. Works for me...


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=484424