Join does not work

**rwgrietveld** · 01-12-2010, 08:30 AM

I have the following function

Please Login or Register  to view this content.

This works, but I was looking at function JOIN() and came up with

Please Login or Register  to view this content.

Obviously the second has a lot of disadvantages, but I just wanted it to work with a single dimensional range A1:A3. Why doesn't it?

**DonkeyOte** · 01-12-2010, 08:34 AM

You would need to transpose your range such that you end up with a single dimension array

Please Login or Register  to view this content.

(were MyRng a horizontal vector rather than vertical vector then you would Transpose twice to get single dimension array)

**romperstomper** · 01-12-2010, 08:34 AM

Because if you assign the value of a range in one go like that, you always get a 2D array.

**rwgrietveld** · 01-12-2010, 08:53 AM

Well,

That sums it up.

THX RS and DO.

**shg** · 01-12-2010, 11:28 AM

And you can't use Join with a Variant.

**Richard Schollar** · 01-12-2010, 11:32 AM

Originally Posted by shg

And you can't use Join with a Variant.

Shg - don't think that's correct. In the Immediate window the following works without issue:

Please Login or Register  to view this content.

Richard

**shg** · 01-12-2010, 11:50 AM

Ya know, that had always puzzled me. I reckon I never got the syntax correct:

Please Login or Register  to view this content.

Thank you, Richard.

Re: Join does not work