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 vote348 views1 answer
Vba line feed
VBA
0 vote342 views1 answer
Excel vba hide columns
VBA
0 vote396 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
1 vote361 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote384 views2 answers
Excel vba number format file size
VBA
0 vote346 views1 answer
Vba format currency
VBA
0 vote385 views1 answer
Make your computer talk vbscript
VBA
0 vote365 views1 answer
Vb.net change cursor to wait
VBA
0 vote512 views1 answer
Vba array of integers
VBA
0 vote371 views2 answers
Checking and changing system volume vb.net
VBA