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 vote129 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote119 views1 answer
Vb.net change cursor to wait
VBA
0 vote123 views1 answer
Excel text to columns line break
VBA
0 vote116 views1 answer
Excel vba copy range with filter
VBA
0 vote134 views4 answers
How to continue formula in below line in vba code
VBA
0 vote123 views1 answer
Return na vba
VBA
0 vote129 views1 answer
Regex numeric digits
VBA
1 vote113 views2 answers
Vba string to date
VBA
31 votes152 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote120 views1 answer
Dynamically change drop down list visual basic
VBA