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 vote203 views1 answer
Vba nested dictionary
VBA
0 vote197 views1 answer
Excel vba show developer tab
VBA
0 vote201 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote157 views1 answer
How to sort datagridview in vb.net
VBA
0 vote206 views1 answer
WGET FTP
VBA
-1 vote225 views1 answer
Code for reading letters only in vb 6
VBA
0 vote209 views1 answer
Find days in month vba
VBA
1 vote160 views1 answer
Vba Remove Case Sensitivity
VBA
5 votes226 views1 answer
Excel-vba get integer high byte
VBA
2 votes224 views1 answer
Vba file from path
VBA