Equating a Worksheet Range To an Array Variable

This is much more convenient than the loop method, where two nested loops would be required to read or write a 2-D range. However, a problem arises when you use this method with a 1-D range, as described next. 

A 1-DIMENSIONAL ARRAY ASSIGNED TO A WORKSHEET RANGE CAN CAUSE PROBLEMS 

Arrays can cause some confusion when you write the array back to a worksheet by assigning the value of the array to a worksheet range. 

For X = 1 To 10 TestArray(x) = 10 + x Next Then writes the array elements to cells E1 E10. Range( E1 E10 ).Value = TestArray End Sub 

If you run the preceding Sub procedure, you will find that cells El through E10 will all contain 11, the first element of the array. However, if you write the array to a row of cells instead of a column, thus  

Range( E1 N1 ).Value = TestArray each cell of the range will receive the correct array value. 

---