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 vote279 views1 answer
Vba select file in folder
VBA
0 vote311 views1 answer
Delete rows in excel vba code
VBA
0 vote315 views1 answer
Excel vba chrw max value
VBA
0 vote304 views1 answer
Reset border color textbox vba
VBA
0 vote318 views1 answer
VBA Sleep Snippet
VBA
0 vote303 views1 answer
Vbnet check if number is even or odd
VBA
0 vote327 views1 answer
Test if form is open vb
VBA
0 vote316 views1 answer
VBA Loop to range
VBA
4 votes309 views2 answers
Vba create folder if not exist
VBA
8 votes360 views1 answer
Excel vba make integer
VBA