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

4 votes128 views2 answers
Excel vba last column with data
VBA
0 vote131 views1 answer
Test if form is open vb
VBA
0 vote132 views1 answer
Vba userform textbox wrap text
VBA
1 vote118 views1 answer
Excel vba autofit
VBA
0 vote130 views1 answer
Vba collection contains
VBA
0 vote123 views1 answer
Excel vba unmerge sheet
VBA
0 vote136 views1 answer
Visual basic cmd
VBA
1 vote86 views1 answer
How to open cmd with vbd
VBA
8 votes164 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote116 views1 answer
Excel vba copy range with filter
VBA