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

2 votes326 views1 answer
Excel vba check if key is in collection
VBA
1 vote328 views1 answer
Excel vba autofit
VBA
0 vote320 views1 answer
Open application from vbnet
VBA
2 votes356 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote337 views1 answer
Ribbon show/hide
VBA
0 vote331 views1 answer
Convert unix to date vba
VBA
22 votes551 views1 answer
Xl vba check for folder
VBA
0 vote350 views1 answer
Vbnet find highest value in chart
VBA
0 vote323 views1 answer
Windows Presentation Foundation dark title bar
VBA
3 votes342 views1 answer
Extract the nth word from a text string
VBA