Solved: populate column with array values

[CatDaddy]

to get the row header i use:


Range("B1:H1").Value = colHeader


colHeader being an array of 7 strings, and when i try the same for the row headers:


Range("A2:A31").Value = rowHeader


it copies rowHeader(1) 31 times instead of the 31 different strings in the rowHeader array...

[CatDaddy]

when i change the range for the rowHeader to "A2:Z2" the array populates correctly...is there a column limitation i am unaware of?

[mikerickson]

Excel sees a 1 dimesional array as a row-wise array.
To put your row headers:Range("A2:A31").Value = Application.Transpose(rowHeader)

[CatDaddy]

THANK YOU! :beerchug: :beerchug: