Does that mean you copy and paste special|transpose 240 times???

You may want to play with that macro to see if it works for you.

zigeuner wrote:

Thank you Dave and Earl. I have no managed it using the transpose
function, albeit without the macro Dave (I have saved it though). Earl
the Access option wouldn't work as the spreadsheet had some functions
embedded in cells that Access could make no sense of. Brian

--
zigeuner
------------------------------------------------------------------------
zigeuner's Profile: http://www.excelforum.com/member.php...o&userid=27527
View this thread: http://www.excelforum.com/showthread...hreadid=470476

--

Dave Peterson