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 vote365 views1 answer
Return na vba
VBA
31 votes503 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote356 views1 answer
Openfiledialog specific folder
VBA
8 votes406 views1 answer
Vba make integer
VBA
0 vote338 views1 answer
Vb window.minimize
VBA
0 vote356 views1 answer
Vba code to open a file with login rights
VBA
0 vote351 views1 answer
Dynamic array vba
VBA
0 vote342 views1 answer
Excel vba show developer tab
VBA
0 vote346 views1 answer
Vba simple quote
VBA
0 vote351 views1 answer
Vba type variable
VBA