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 vote192 views1 answer
Excel vba extract year
VBA
15 votes349 views1 answer
Excel vba wait
VBA
0 vote180 views1 answer
Vlookup columns not next to each other
VBA
3 votes177 views1 answer
Vba folderexists
VBA
0 vote195 views1 answer
Freeze panes vba
VBA
0 vote196 views2 answers
Excel vba protect cells with formula
VBA
1 vote185 views1 answer
Change the first item in a queue vb.net
VBA
0 vote193 views2 answers
Do until loop vba
VBA
0 vote191 views1 answer
Excel vba urlmon
VBA
20 votes443 views1 answer
Excel vba factorial
VBA