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 vote186 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote175 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote174 views1 answer
Make all controls in an area not visable vb
VBA
1 vote189 views1 answer
Vba optional
VBA
0 vote164 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote174 views1 answer
Vba string
VBA
0 vote170 views1 answer
Vba open report
VBA
0 vote184 views1 answer
Vbs expand env var
VBA
0 vote183 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote209 views1 answer
Vbnet check if string is only numbers
VBA