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 vote246 views1 answer
Set datetimepicker value to null vb
VBA
0 vote219 views1 answer
Vba sheet hide unhide
VBA
0 vote198 views1 answer
Vba remove numbers from string
VBA
0 vote203 views1 answer
Excel vba center userform
VBA
0 vote219 views1 answer
Set column width of datagridview vb.net
VBA
0 vote214 views1 answer
Create links in msgbox in vb
VBA
0 vote237 views1 answer
Excel vba scroll to cell
VBA
1 vote238 views1 answer
Vba format string as cash
VBA
25 votes541 views3 answers
String to date vb
VBA
0 vote209 views1 answer
Vbnet check if number is even or odd
VBA