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 vote212 views1 answer
Add items to combobox vb.net
VBA
1 vote242 views1 answer
Perform http request in vb.net
VBA
1 vote220 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote209 views1 answer
Hello world vb.net
VBA
0 vote210 views1 answer
Afficher un message d'erreur vba
VBA
0 vote218 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote234 views1 answer
VBA is form loaded
VBA
0 vote233 views1 answer
Prive sub enter clicked vb
VBA
0 vote256 views1 answer
Check if cell is dbnullvb.net
VBA
2 votes161 views2 answers
Vba exit loop
VBA