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 vote162 views1 answer
Excel vba unlock sheet without password
VBA
2 votes146 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote131 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote129 views1 answer
Remove frist letter from string vbnet
VBA
0 vote165 views1 answer
Excel vba move down to next visible cell
VBA
0 vote144 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote189 views1 answer
Visual basic cmd
VBA
0 vote143 views1 answer
Vba character ascii code
VBA
0 vote148 views1 answer
Excel vba convert cells address
VBA
5 votes143 views1 answer
Excel vba high word from Long Integer
VBA