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 vote262 views1 answer
Tester si une case est vide vba
VBA
0 vote219 views1 answer
Vba dropdown event
VBA
0 vote219 views1 answer
Vba copy paste value only
VBA
0 vote226 views1 answer
Vba collection key list
VBA
0 vote249 views3 answers
Write to text file vb.net
VBA
5 votes242 views1 answer
Xlvba double quotes in string literal
VBA
0 vote234 views1 answer
Make all controls in an area not visable vb
VBA
0 vote248 views1 answer
Vba add spaces
VBA
0 vote237 views1 answer
Regex numeric digits
VBA
0 vote246 views1 answer
Excel vba protect scenarios
VBA