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 vote383 views1 answer
Test if form is open vb
VBA
0 vote398 views1 answer
Vba boolean to string
VBA
0 vote374 views1 answer
For each item in folder outlook vba
VBA
1 vote350 views1 answer
Excel date to unix timestamp
VBA
0 vote315 views1 answer
How to sort datagridview in vb.net
VBA
0 vote390 views1 answer
Excel delete ever other vba
VBA
22 votes583 views1 answer
Xl vba check for folder
VBA
0 vote355 views1 answer
Excel vba copy entire sheet paste values
VBA
1 vote392 views2 answers
Vba string length
VBA
8 votes520 views1 answer
Vba convert 2 bytes to an integer
VBA