Reading range into static array

[welchs101]

I am enclosing a file for reference.

I have a static array that is 377 elements. I am trying to read in 377 cells from sheet1 col-A into the array but i get an error. Not sure whats wrong. Can someone help?

[DonkeyOte]

To assign the Range to the Array in one go you would need to make the Array of Variant Type (it would be 2 dimensional at that point unless you were to Transpose the Range)

Please Login or Register  to view this content.

the above would be (1 to n, 1 to 1) to remove 2nd dimension you would transpose the Range as mentioned previously (for a vertical vector 1 transpose, for horizontal vector 2)

Please Login or Register  to view this content.

If you want to keep the Array of String type you would be obliged to iterate the Range and populate the Array on an item by item basis.