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 vote332 views1 answer
Vba copy file
VBA
1 vote311 views1 answer
Close form vba
VBA
0 vote462 views1 answer
Vba change active sheet
VBA
0 vote346 views1 answer
Excel vba disable screen update
VBA
0 vote349 views1 answer
How to enter Vbox manage commands
VBA
0 vote311 views1 answer
Vba select file in folder
VBA
22 votes479 views1 answer
Excelvba check for directory
VBA
0 vote327 views2 answers
Excel vba protect cells with formula
VBA
3 votes350 views2 answers
Vba active workbook path
VBA
0 vote328 views1 answer
Type excel.application is not defined vb
VBA