Excel vba join variant array

Public Function ConcatenateRange(pRange As Range, Optional pDelimiter As String = " ") As String
    ConcatenateRange = Join(WorksheetFunction.Transpose(pRange.Value), pDelimiter)
End Function

Sub TestMe()
    Dim r As Range
    Set r = ThisWorkbook.Worksheets(1).Range("A1:A10")
    MsgBox ConcatenateRange(r)
End Sub

Similar codes

1 vote111 views2 answers
Vba function return array
VBA
1 vote110 views1 answer
What does vbs stand for
VBA
0 vote116 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote117 views1 answer
Vb.net change cursor to wait
VBA
1 vote126 views1 answer
Excel vba autofit
VBA
0 vote118 views1 answer
Vbnet check if string is only symbols
VBA
0 vote114 views1 answer
Vba DisplayGridlines
VBA
0 vote120 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote113 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote130 views1 answer
VBA Sort RossetaCode
VBA