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 vote176 views1 answer
Vb run command
VBA
0 vote154 views1 answer
Excel vba populate array with cell values
VBA
0 vote167 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote172 views1 answer
Excel vba array remove first
VBA
0 vote170 views1 answer
Vba DisplayGridlines
VBA
0 vote167 views1 answer
Excel vba StartUpPosition
VBA
1 vote159 views2 answers
Get all column names from excel vba
VBA
5 votes141 views1 answer
Vba array worksheet.index
VBA
1 vote153 views1 answer
How to do error handling in access vba
VBA
0 vote159 views1 answer
Vba code to open a file with login rights
VBA