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 vote278 views1 answer
Excel vba center userform
VBA
6 votes321 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote291 views1 answer
Prive sub enter clicked vb
VBA
0 vote291 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote296 views1 answer
Excel vba clear filter
VBA
0 vote286 views1 answer
String contins in vba
VBA
0 vote275 views1 answer
Vba add month to date
VBA
0 vote264 views1 answer
Excel vba hide columns
VBA
0 vote305 views1 answer
Vba random number
VBA
8 votes410 views1 answer
Excel vba make word from bytes
VBA