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

3 votes386 views1 answer
Extract word in a text in excel
VBA
0 vote332 views1 answer
Vb run command
VBA
0 vote361 views1 answer
Excel vba urlmon
VBA
4 votes340 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote320 views1 answer
Vba format currency
VBA
0 vote350 views1 answer
Add text to combobox drop down vb
VBA
1 vote340 views1 answer
Excel vba compare 2 rows
VBA
-1 vote392 views1 answer
Vba sendkeys
VBA
0 vote319 views1 answer
Vba string start with
VBA
0 vote355 views1 answer
Vba add spaces
VBA