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 vote223 views1 answer
Limit combobox to list vba
VBA
0 vote234 views1 answer
Excel last used row
VBA
0 vote212 views1 answer
Vba add month to date
VBA
0 vote222 views1 answer
Excel vba send HTTP POST to server
VBA
5 votes228 views1 answer
Xl vba double quotes in string literal
VBA
31 votes511 views1 answer
Excel vba function to convert column number to letter
VBA
-1 vote251 views1 answer
Text to speech vb.net
VBA
0 vote216 views1 answer
Handling a click event anywhere inside a panel vb
VBA
1 vote233 views1 answer
Vba login website
VBA
25 votes510 views2 answers
Excel vba folder exist
VBA