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 vote282 views1 answer
Type excel.application is not defined vb
VBA
1 vote283 views2 answers
Vba string to date
VBA
0 vote301 views1 answer
Vba character ascii code
VBA
0 vote284 views1 answer
Vba get application version
VBA
0 vote306 views1 answer
Vba keep command window open
VBA
0 vote311 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
-1 vote270 views1 answer
Text to speech vb.net
VBA
1 vote284 views1 answer
Vba refresh pivot table
VBA
1 vote274 views1 answer
Excel vba close form escape key
VBA
0 vote276 views1 answer
Change whcih control a user has selected vb
VBA