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 vote266 views1 answer
Vbnet display all axis labels in cahrt
VBA
8 votes395 views1 answer
Excel vba make word from bytes
VBA
0 vote336 views2 answers
Excel vba store array and write to sheet
VBA
0 vote262 views1 answer
Refresh token em vb net
VBA
0 vote292 views1 answer
Excel vba set cell value to empty
VBA
0 vote254 views1 answer
Excel vba existence of a file
VBA
0 vote276 views1 answer
Return na vba
VBA
0 vote239 views1 answer
Vba select file in folder
VBA
0 vote278 views1 answer
Search combobox items vb.net
VBA
1 vote296 views1 answer
Find and replace textbox
VBA