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 vote367 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote374 views1 answer
Vba registry settings
VBA
0 vote367 views1 answer
Columns dont autoresize on program start vb.net
VBA
-1 vote410 views1 answer
Vba sendkeys
VBA
1 vote345 views1 answer
How to open cmd with vbd
VBA
0 vote350 views1 answer
String contins in vba
VBA
0 vote376 views1 answer
Vba min
VBA
0 vote389 views1 answer
VBA
VBA
1 vote349 views2 answers
Vba string to date
VBA
0 vote351 views1 answer
Vba copy file
VBA