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 vote177 views1 answer
Vba option button selected
VBA
0 vote179 views1 answer
Excel vba range contains
VBA
0 vote179 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote165 views2 answers
Excel vba prevent save
VBA
0 vote201 views1 answer
Vba change active sheet
VBA
22 votes345 views1 answer
Excel vba check if directory exists
VBA
2 votes174 views1 answer
Excel vba check if key is in collection
VBA
0 vote179 views1 answer
Vba compare strings
VBA
0 vote214 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote178 views1 answer
Excel vba calculate
VBA