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 vote229 views1 answer
Tester si une case est vide vba
VBA
5 votes202 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote219 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote215 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote197 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote194 views1 answer
Vba createparameter null
VBA
0 vote205 views1 answer
Excel vba copy range with filter
VBA
4 votes203 views2 answers
Vba last row
VBA
1 vote207 views1 answer
Excel date to unix timestamp
VBA
0 vote211 views1 answer
Vba test optional argument
VBA