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

-1 vote295 views2 answers
Excel vba delete empty rows
VBA
0 vote305 views1 answer
Vba multiple optional arguments
VBA
1 vote303 views2 answers
Get all column names from excel vba
VBA
0 vote273 views1 answer
Excel vba formatconditions range
VBA
0 vote285 views1 answer
Hello world vb.net
VBA
2 votes281 views1 answer
Excel vba date to string conversion
VBA
6 votes327 views1 answer
Excel vba get the path of current workbook
VBA
0 vote297 views1 answer
Vbnet click on dgv cells
VBA
0 vote311 views1 answer
Excel vba copy range with filter
VBA
1 vote286 views1 answer
Excel vba get ordinal number from cardinal number
VBA