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 vote286 views1 answer
Vba line feed
VBA
0 vote293 views1 answer
Vba leading zeros in string
VBA
0 vote291 views1 answer
Thread sleep vb
VBA
0 vote293 views1 answer
Vbscript check if string is empty
VBA
1 vote309 views1 answer
Excel vba to lower case
VBA
0 vote308 views1 answer
Vba variable number of arguments
VBA
2 votes296 views2 answers
Excel vba copy values range to another range
VBA
3 votes301 views1 answer
Excel insert blank row for value change in column
VBA
0 vote307 views1 answer
Excel vba prevent saving workbook
VBA
1 vote307 views1 answer
How to remove zeros in excel
VBA