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 vote136 views1 answer
Check if program is running vbnet
VBA
0 vote140 views1 answer
Vba keep command window open
VBA
3 votes149 views1 answer
Extract word in a text in excel
VBA
0 vote121 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote130 views1 answer
Vba get workbook name
VBA
1 vote141 views1 answer
Excel date to unix timestamp
VBA
0 vote128 views1 answer
Vb get ip address
VBA
0 vote148 views1 answer
Tester si une case est vide vba
VBA
0 vote142 views1 answer
Vba clear collection
VBA
0 vote132 views1 answer
Reference to a non-shared member requires an object reference
VBA