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 vote188 views1 answer
Excel vba copy range with filter
VBA
0 vote179 views1 answer
Vba file size
VBA
3 votes185 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote189 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote197 views1 answer
Build an index all files of a FTP site
VBA
0 vote173 views1 answer
Docker vboxmanage not found
VBA
1 vote207 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote192 views1 answer
Vba word pdf table to excel
VBA
4 votes189 views1 answer
Vba create directory
VBA
0 vote194 views1 answer
Excel vba formatconditions positive
VBA