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

1 vote219 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote231 views1 answer
Make your computer talk vbscript
VBA
0 vote229 views1 answer
VBA Sleep Snippet
VBA
0 vote239 views1 answer
Vba exit while
VBA
0 vote267 views1 answer
Vba code for cutoff time
VBA
0 vote226 views2 answers
Excel vba close without saving
VBA
0 vote210 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote252 views1 answer
Vba code to select image in sheet
VBA
0 vote289 views1 answer
Visual basic run command
VBA
1 vote231 views1 answer
Add a index column power bi
VBA