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 vote153 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote159 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote168 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
2 votes161 views1 answer
Vba file from path
VBA
0 vote148 views1 answer
Get current year vb
VBA
0 vote170 views1 answer
Vba clear collection
VBA
0 vote168 views1 answer
If statement vdhl
VBA
0 vote152 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
5 votes158 views1 answer
Xl vba double quotes in string literal
VBA
1 vote149 views2 answers
Vba find last row in range for certain criteria
VBA