VBAで配列を1文字列に合体

Sub JoinTest()
    Dim ar(2)   As String
    
    ar(0) = "aa"
    ar(1) = "bbb"
    ar(2) = "cccc"
    
    Dim s       As String
    
    s = Join(ar, ",")
    
    Debug.Print s
End Sub

ネタ元

• https://vbabeginner.net/vba%E3%81%A7%E9%85%8D%E5%88%97%E3%81%AE%E5%85%A8%E8%A6%81%E7%B4%A0%E3%82%92%E9%80%A3%E7%B5%90%E3%81%97%E3%81%A6%E6%96%87%E5%AD%97%E5%88%97%E3%81%AB%E3%81%99%E3%82%8B%EF%BC%88join%EF%BC%89/