In addition to checking the 'transpose' box when doing Copy/Paste
Special... select Paste: Values. This will paste the contents of the
cell instead of the formulas (which may result in the #ref error).

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=498265