How do I populate a range of cells with an array created in VBA?

**par0016** · 04-12-2013, 12:26 AM

I am brand new to VBA (taught myself) and this is probably a very simple and stupid question but I have an array in VBA and I can't for the life of me get it into the ranges I specify. Instead it just populates the cells I have specified with the first value of the array. The even more perplexing part is that when I manually place them in the cells (aka range("A1") = MyArray(1), range("A2") = MyArray(2)) it works perfectly. Obviously that isn't what I want to do though.

I currently am trying to populate the range using this:

Range("A1:A20") = MyArray

I have also tried:

Range("A1:A20").Value = MyArray

I have already transposed MyArray and it is dimmensioned as Dim MyArray(1 to 20) as variant.

Please give me something, I am sure this is so simple, but I am completely at a loss.

**patel45** · 04-12-2013, 02:44 AM

Sub arraytorange()
arr = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
Range("E1:N1") = arr
Range("E1:E10") = Application.Transpose(arr)
End Sub

How do I populate a range of cells with an array created in VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do I populate a range of cells with an array created in VBA?

Re: How do I populate a range of cells with an array created in VBA?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions