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

1 vote149 views1 answer
Add control vb
VBA
0 vote152 views1 answer
Get current url vb.net
VBA
0 vote139 views1 answer
Vbnet display all axis labels in cahrt
VBA
6 votes152 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote170 views1 answer
Vba search string position
VBA
2 votes175 views2 answers
Excel vba if sunday or staurday
VBA
0 vote165 views1 answer
For each item in folder outlook vba
VBA
0 vote145 views1 answer
Vba collection key list
VBA
0 vote145 views1 answer
Enter into cells data grid view
VBA
0 vote171 views1 answer
Excel web scraping
VBA