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 vote138 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote141 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote140 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
1 vote134 views1 answer
Vba delete file
VBA
0 vote151 views1 answer
Excel filter by date not working vba
VBA
0 vote97 views10 answers
Vba excel create event log
VBA
0 vote149 views1 answer
Excel run macro every 5 minutes
VBA
0 vote148 views1 answer
Priavte sub with multiple handels find sneder
VBA
32 votes267 views2 answers
Excel vba column letter
VBA
0 vote137 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA