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 vote187 views1 answer
Get month number from month name vbnet
VBA
0 vote174 views1 answer
Limit combobox to list vba
VBA
0 vote183 views1 answer
Vba exit while
VBA
0 vote172 views1 answer
Vbnet check if string is only symbols
VBA
0 vote184 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote197 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote189 views1 answer
Vba integer to double
VBA
1 vote172 views1 answer
Change the first item in a queue vb.net
VBA
0 vote191 views1 answer
Vba round to 2 decimals
VBA
4 votes170 views1 answer
Excel vba determine number of elements in an array
VBA