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 vote217 views1 answer
Select case vba
VBA
0 vote224 views1 answer
Vbs write file
VBA
0 vote217 views1 answer
Vba border weight
VBA
0 vote227 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote227 views1 answer
Excel vba extract year
VBA
4 votes170 views2 answers
Vba last row
VBA
0 vote233 views1 answer
Write listbox to text file vb.net
VBA
5 votes251 views1 answer
Excel vba how to unit test vba code
VBA
0 vote219 views1 answer
How to use if condition in time vba
VBA
0 vote248 views1 answer
Find database connection string vb
VBA