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

1 vote130 views1 answer
Excel vba hide zero values
VBA
0 vote82 views1 answer
Excel autofilter vba
VBA
0 vote145 views1 answer
Vb run command
VBA
2 votes93 views1 answer
Excel vba pause
VBA
0 vote139 views1 answer
Vba sort the data Z to A
VBA
0 vote140 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote144 views1 answer
Vba horizontalalignment
VBA
1 vote146 views1 answer
Export datagridview to excel vb.net
VBA
0 vote138 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote143 views1 answer
Vba array dimensions
VBA