join application.yranspose code to add a separator

[ash3angel]

hi how can i add a separator when doin this code, instead of space i want to make it a comma.

range("b1") = join(application.transpose(range("a1:a10)))

thank ypu

[MickG]

Try:-

Please Login or Register  to view this content.

[MarvinP]

Hi,

How about replacing each space with a comma space like:

range("b1")= worksheetfunction.substitute(join(application.transpose(range("a1:a10")))," ",", ")

[bakerman2]

Why Worksheetfunction ?

Please Login or Register  to view this content.

[ash3angel]

thanks all, 1st and 2nd answer went well the way i want, im nt sure the 3rd one it does not capture the comma

[bakerman2]

Please Login or Register  to view this content.