Concatenate array problem.

[Jack Schitt]

I should like a general solution to the following problem, preferably not
involving VBA.

I have two named ranges, Range1 and Range2
Each range has the same number of columns, although the number of rows in
each need not be the same.

I want to generate a named array MyArray that has the same number of
columns, as Range1 or Range2, a number of rows equal to the sum of the
number of rows in Range1 and Range2, and which contains each of the elements
of Range1 and Range2 stacked one above the other.

Eg:
Range1 refers to $A$1:$A$5
Range2 refers to $B$6:$B$20
Cell A1 contains value 1
Cell A2 contains value 2
etc
Cell B6 contains value 6
Cell B7 contains value 7

MyArray needs to evaluate to:
{1;2;3;....;20}
by reference to a function of Range1 and Range2

Help?

 

[Frank Kabel]

Hi
maybe you could explain what you want to do with the resulting array