Would this work for you using the later versions of Excel.
This demo starts at Cell A1 for a size of 50.
Sub Demo()
Dim Str As String
Dim n As Long
n = 50
Str = Join(WorksheetFunction.Transpose(Range("A1").Resiz e(n)),
vbNullString)
End Sub
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"mozart" wrote in
message ...
Yes that would seem the way to do it but it could become painful if say
your range was say 50 cells let alone 62k.
Thanks
--
mozart
------------------------------------------------------------------------
mozart's Profile:
http://www.excelforum.com/member.php...o&userid=13314
View this thread: http://www.excelforum.com/showthread...hreadid=533112