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 vote233 views1 answer
Excel vba formatconditions range
VBA
0 vote236 views1 answer
Vba string start with
VBA
0 vote243 views1 answer
Vbnet check if string is only numbers
VBA
0 vote240 views1 answer
Loop through lines in text file vb net
VBA
3 votes224 views1 answer
Excel vba last row in range
VBA
5 votes276 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote224 views1 answer
Add Formula to Shape Text in VBA
VBA
1 vote235 views1 answer
Vba compile error object required
VBA
0 vote246 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote229 views1 answer
Find days in month vba
VBA