Excel VBA String

Is there a way to get a range("A1:A10") into a comma delimited string in Excel, without using a loop?

Moved :)

VB Code:

mystr = range("A1") & "," & range("A2") & "," & ....

So what if you have a range of "A1:A100" ? :D

Well, most of us would use a loop...

Yup, be using a Loop is not desired. :D

That is what I am using right now (a loop), but there has to be an easier way to do it. If I find it, I will post.