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 vote238 views1 answer
Vba registry settings
VBA
5 votes233 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote213 views1 answer
VB Error Code BC30201
VBA
0 vote205 views1 answer
Vba variable number of arguments
VBA
0 vote219 views1 answer
Freeze panes vba
VBA
1 vote233 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote210 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote229 views1 answer
Vba count all row
VBA
0 vote209 views2 answers
Excel vba protect cells with formula
VBA
0 vote202 views1 answer
Vba line feed
VBA