CODEWITHSUNDEEP
arraysexceloutputvba
user2734645
user2734645

Reputation: 31

Output VBA Array Elements to One Cell in Excel

So i have a vba code that creates an array with multiple elements. I would like to output those elements into one cell in excel. Im able to output its elements to multiple cells but prefer it in one cell. Can this be done?

Upvotes: 3

Views: 8244

Answers (1)

Andy G
Andy G

Reputation: 19367

If the array is declared as a String or Variant then you can use Join:

Sub AllIntoOne()
    Dim arr(1 To 3) As Variant
    arr(1) = 4
    arr(2) = 54
    arr(3) = 3
    Range("A1") = Join(arr, ",")

End Sub

The delimiter "," defaults to a space if not supplied, but can be an empty string "" if no separation is required.

Upvotes: 4

Related Questions