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 vote224 views1 answer
Sendkeys vba selenium
VBA
22 votes483 views1 answer
Excelvba check for directory
VBA
1 vote208 views1 answer
Excel vba autofit
VBA
1 vote193 views1 answer
VBA Loop through recordset
VBA
0 vote204 views1 answer
Vba test optional argument
VBA
0 vote208 views1 answer
Date as number vb
VBA
1 vote204 views1 answer
Excel vba unload userform
VBA
0 vote199 views1 answer
Visual basic msdos
VBA
3 votes229 views2 answers
Vba active workbook path
VBA
0 vote161 views1 answer
Vba code to remove leading and trailing spaces
VBA