multi-array [2D] create on fly from split - is it possible ?

[MaczaQ]

Dear Forum,

I have a question about Arrays. I can do something like this:

Please Login or Register  to view this content.

but i wondering if there is any way to input there some values on the fly i.e. after some input

conception:

Please Login or Register  to view this content.

[Chippy]

If you are asking how to join (concatenate) two 2-dimensional arrays, try CombineTwoDArrays or ConcatenateArrays at http://www.cpearson.com/excel/vbaarrays.htm.

[MaczaQ]

Hi Chippy, thx for reply. I already saw that site - I'm looking for just easier way to create 2d array - probable it doesnt exists But I will still try to find a way

[jindon]

Please Login or Register  to view this content.

[lecxe]

Hi

A similar option, not transposing:

Please Login or Register  to view this content.

[MaczaQ]

@jinodon, @lecxe - It's just what I looking for. Thank you very much for your replaies