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 vote128 views2 answers
Excel vba number format file size
VBA
1 vote135 views1 answer
Excel vba autofit
VBA
0 vote126 views1 answer
Excel vba Column Name from Column Number
VBA
3 votes144 views1 answer
Extract word in a text in excel
VBA
0 vote118 views1 answer
Afficher un message d'erreur vba
VBA
3 votes133 views1 answer
Excel vba change format of cell
VBA
2 votes133 views2 answers
Vba code to remove duplicates from a column
VBA
5 votes149 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote131 views1 answer
Weekday vba
VBA
1 vote126 views1 answer
Excel vba close form escape key
VBA