Excel vba concatenate range

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 vote237 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote234 views1 answer
Vb streamreader
VBA
5 votes251 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote226 views1 answer
Vbscript for loop
VBA
0 vote242 views1 answer
Vb.net change cursor to wait
VBA
0 vote264 views1 answer
.net crash app
VBA
1 vote250 views1 answer
Vba optional
VBA
0 vote251 views1 answer
Iterate all file in a folder vba
VBA
0 vote248 views1 answer
Windows Forms dark title bar
VBA
0 vote226 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA