Hi Rick - Here is the clarification:

(1) The amount of data in the range is not constant. Therefore, the
"last cell" filled could be in the "right-most" column, or the column
next to the "right-most" or the column 2nd next to the "right-most"
column, and so on. The direction of the data is this way: "Fill the
"left-most" column B:B (from top-down), then continue in the next
"left-most" column D:D (from the top-down),then continue in the next
"left-most" column F:F (from the top-down), and so on..

(2) The type of array I am looking to end up with is either a (1 row by
N columns) OR (N rows by 1 column)., where N is the number of cells
containing data in the "snake-like" range structure.. (that is, starting
from B1 to B65536, then continuing from D1 (acting as the 65537th cell)
through D65536 (acting as cell 2*65536), then continuing in F1 through
F65536, and so on.

I hope this clears it up.
Thanks
Jay

*** Sent via Developersdex http://www.developersdex.com ***