Home » Blogs » Vishesh's blog

Concatenate Array

Vishesh's picture
Submitted by Vishesh on 23 March, 2011 - 17:59

This is a small piece of code that can be used to concatenate the elements of an array.

You can use it on elements of a listbox or combobox. See the attached file for reference.

  

Function ConcatenateArrayElements(arrElement As Variant, Optional  _ 
strConcatenator As String = ", ") As String
 
 ConcatenateArrayElements = Join(arrElement, strConcatenator)
 
End Function

 

 

Concatenate_Array

AttachmentSize
ConcatenateArray.xls24 KB
»
YasserKhalil's picture

How can I concatenate from

Submitted by YasserKhalil on 5 May, 2015 - 16:06.

How can I concatenate from the range itself

MsgBox ConcatenateArrayElements(Sheet1.Range("A2:A6"), ", ")

»