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

6 votes178 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote183 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
3 votes216 views2 answers
Vba date to string
VBA
0 vote170 views1 answer
How to use VBA to add new record in MS Access?
VBA
5 votes190 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote171 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote175 views1 answer
Select case vba
VBA
5 votes177 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote187 views1 answer
Vba paste values
VBA
0 vote169 views1 answer
Vbnet get file name from path
VBA