join values in range

Hello again friends,

I'm trying to join multiple values in a range into a coma separated string. I used the following code:

Please Login or Register  to view this content.

If you can help pls?

You can only JOIN a 1 dimensional array, when you populate an array from a range it creates a 2 dimensional one. You'll need to transpose the array first.

I've tried your suggestion but same result:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

like a charm! thank you!
Why is that working?
What is different now?

I'm getting an error because your procedure is named join, so I changed that and used transpose twice and it works fine.
To answer your question, when you populate you array with data that's all in a row you get an array that's 1 row and 10 columns. When you use transpose you change that to an array that is 1 column and 10 rows and when you transpose that you get a 1d array of 10 items. So transpose(transpose) does that in one line of code. If your data starts in a column say A1:A10 then you only need transpose once.
Run the following code line by line and look at how arr changes in the locals window.

Please Login or Register  to view this content.

thank you guys!

Thanks for the rep. points.