Excel vba join variant array

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 vote172 views1 answer
Excel vba delete folder
VBA
5 votes187 views1 answer
Xlvba double quotes in string literal
VBA
0 vote173 views1 answer
Make all controls in an area not visable vb
VBA
0 vote169 views2 answers
How to concatenate more than 40 lines in vba
VBA
4 votes172 views1 answer
Vba create directory
VBA
0 vote178 views1 answer
Vbnet check if sting contians symbols
VBA
1 vote162 views2 answers
Vba remove first 2 characters from string
VBA
0 vote175 views1 answer
Vba get application version
VBA
0 vote172 views1 answer
Excel vba clear filter
VBA
0 vote181 views1 answer
Excel delete ever other vba
VBA