I don't know if this works, but once you've copied your address, try
Paste Special Transpose.

Alternatively, paste the data in so it initially goes in vertically,
then copy it within the Excel document and do the same Paste Special
Transpose operation.

HTH,

Samuel T


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=560173