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

6 votes239 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote245 views1 answer
Send webhook vbscript
VBA
0 vote232 views1 answer
Excel vba hide gridlines
VBA
0 vote265 views1 answer
Vba userform textbox wrap text
VBA
0 vote231 views1 answer
Excel vba scroll to cell
VBA
11 votes299 views1 answer
Excel vba How to URL encode a string
VBA
0 vote258 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote228 views1 answer
Vbscript check if string contains
VBA
0 vote226 views1 answer
Vba find sub dictionary
VBA
8 votes224 views1 answer
Excel vba make a short integer from two bytes
VBA