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

0 vote331 views1 answer
Vba check if class implements interface
VBA
1 vote332 views1 answer
Vba reverse string
VBA
0 vote325 views1 answer
Excel vba address not absolute
VBA
0 vote338 views1 answer
For each item in folder outlook vba
VBA
1 vote321 views1 answer
Sort using vba
VBA
0 vote344 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote339 views1 answer
Vba compare strings
VBA
5 votes378 views1 answer
Excel vba low word from Long Integer
VBA
0 vote327 views1 answer
Remove frist letter from string vbnet
VBA
0 vote339 views1 answer
Power query M substract minimum value of column -dax
VBA