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 vote244 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote294 views1 answer
Visual basic cmd
VBA
0 vote236 views1 answer
Excel named range sum
VBA
1 vote255 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote222 views1 answer
Le contrôle SpinButton (Toupie)
VBA
3 votes316 views1 answer
Excel vba make long from two shorts
VBA
1 vote224 views1 answer
Excel vba hide zero values
VBA
22 votes528 views1 answer
Excel vba check if directory exists
VBA
1 vote234 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
15 votes532 views2 answers
Xl vba dynamic string array
VBA