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

1 vote319 views1 answer
Excel vba compare 2 rows
VBA
5 votes365 views1 answer
Excel-vba get integer high byte
VBA
0 vote299 views1 answer
Do until vb.net
VBA
0 vote305 views1 answer
How to make a a msgbpx in vbs
VBA
6 votes352 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote321 views1 answer
Convert number to minutes in vba
VBA
0 vote329 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote352 views1 answer
Vba nested dictionary
VBA
0 vote337 views1 answer
Excel vba urlmon
VBA
4 votes319 views2 answers
Excel vba last column with data
VBA