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

5 votes192 views1 answer
Excel-vba get integer high byte
VBA
0 vote192 views1 answer
Rotate image by any angle vb.net
VBA
0 vote193 views1 answer
WGET FTP
VBA
0 vote180 views1 answer
Excel vba disable keyboard input
VBA
0 vote201 views1 answer
Vba horizontalalignment
VBA
0 vote184 views1 answer
Get current year vb
VBA
0 vote245 views1 answer
Vba vbcrlf chr
VBA
1 vote174 views1 answer
Excel vba compare 2 rows
VBA
27 votes258 views2 answers
Vba check if file exists
VBA
0 vote176 views1 answer
Excel vba Column Name to Column Number
VBA