Dim myArray

myArray = Application.Transpose(Range("myRange"))
MsgBox myArray(1)


--
__________________________________
HTH

Bob

"greg" wrote in message
...
I have a named range. Lets say it goes over lots of cells.
A1 to E20

Can I get the values out as a string? Single string.

I have tried some things like:

excel.Workbooks(MyWorkbook).Worksheets(MyWorksheet ).Range(MyRange).value

any ideas