You shouldn't have to - afterall, "demo'd from the immediate window" means
the code was successfully executed. But if it works, I don't see a problem
with that.

--
Regards,
Tom Ogilvy


"steveh" wrote in message
...
Thanks, Tom. That worked great. I just had to use WorksheetFunction
instead of Application.


Tom Ogilvy wrote:
Demo'd from the immediate window:

v = Application.Transpose( _
Application.Transpose(range("A1").Resize(1,5)))
s = Join(v,",")
? s
AA,BB,CC,DD,EE


if the cells are in a column, you only need one Application.Transpose