Copy the range and Paste Special select the "Transpose" check box
--
Thanks for your help -
Joe Mac


"beatrice25" wrote:


...10 rows of 8 cells

Any ideas

Many thanks

Beatrice


--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505
View this thread: http://www.excelforum.com/showthread...hreadid=543812