Problem assigning elements in row to array

**welchs101** · 11-11-2011, 07:31 AM

See enclosed file.

I am trying to assign the contents A1 to I1 to an array but for some reason only the first cell is getting loaded into the array.......any thoughts

**Steffen Thomsen** · 11-11-2011, 07:54 AM

Please Login or Register  to view this content.

**welchs101** · 11-11-2011, 07:56 AM

hi, thanks for the reply but i am looking for code which passes the entire range to the array in one shot.......much faster that way.........but yours does work.

**welchs101** · 11-11-2011, 07:59 AM

i recalled an earlier post on this site.......i think i figured out problem was with the "ubound" statement. I needed to use the correct ubound statement and now it works

Please Login or Register  to view this content.

**Steffen Thomsen** · 11-11-2011, 08:04 AM

Then you have to transpose your values first

Please Login or Register  to view this content.

**Steffen Thomsen** · 11-11-2011, 08:06 AM

This creates an array with 1 column and 9 rows,

The other created an array with 9 columns and 1 row

Therefore you needed to get to your data with

header_array(1,[1-9])

Whereas the modified code i just gave you, you can get to the data with

header_array([1-9])