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 vote178 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote169 views1 answer
For each item in folder outlook vba
VBA
0 vote155 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote141 views1 answer
Vba argument is set
VBA
0 vote176 views1 answer
Excel vba named range exists
VBA
4 votes158 views2 answers
Vba create folder if not exist
VBA
0 vote161 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote157 views1 answer
Convert unix to date vba
VBA
0 vote164 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote159 views1 answer
Rotate image by any angle vb.net
VBA