Excel vba concatenate range

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 vote157 views1 answer
How to extract a file from an ISO:
VBA
0 vote162 views1 answer
Returns an array from function vba
VBA
0 vote160 views1 answer
Vba find last column in a row with data
VBA
5 votes174 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote176 views1 answer
Vba loop through files in folder
VBA
0 vote162 views1 answer
Vba static variable
VBA
0 vote159 views1 answer
Compare dates vb
VBA
2 votes146 views1 answer
Vba array contains
VBA
1 vote152 views1 answer
Vba delete array element
VBA
0 vote170 views1 answer
Regex numeric digits
VBA