Excel vba join variant array

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 vote263 views1 answer
Wpf dark title bar
VBA
0 vote249 views1 answer
Vba registry settings
VBA
1 vote197 views1 answer
Vba listindex select multiple items vba
VBA
0 vote214 views1 answer
Vba parameter adodb null value
VBA
0 vote212 views1 answer
Excel vba remove formatting from cell
VBA
0 vote240 views1 answer
Vba timestamp -- milliseconds
VBA
3 votes221 views1 answer
Excel vba change format of cell
VBA
0 vote240 views1 answer
Send text to clipboard vb.net
VBA
0 vote221 views1 answer
Search in richtextbox vb.net
VBA
5 votes253 views1 answer
Vba low word from Long Integer
VBA