Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to union two array with same structure
maybe it's stupit question :)
but it's quite convenient for me in my case. anyone know how to union two array which have same structure into one array. for example: array1 = ( (1,1),(1,2),(1,3)) array2 = ((2,1),(2,2)) I wanna get a new array like that array3 = ( (1,1),(1,2),(1,3),(2,1),(2,2)) thanks in advance :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to union two array with same structure
miao jie wrote:
maybe it's stupit question :) but it's quite convenient for me in my case. anyone know how to union two array which have same structure into one array. for example: array1 = ( (1,1),(1,2),(1,3)) array2 = ((2,1),(2,2)) I wanna get a new array like that array3 = ( (1,1),(1,2),(1,3),(2,1),(2,2)) thanks in advance :) Are the arrays 0-based or 1-based (or something else)? Are they 1-dimensional or 2-dimensional? Alan Beban |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to union two array with same structure
miao jie wrote:
maybe it's stupit question :) but it's quite convenient for me in my case. anyone know how to union two array which have same structure into one array. for example: array1 = ( (1,1),(1,2),(1,3)) array2 = ((2,1),(2,2)) I wanna get a new array like that array3 = ( (1,1),(1,2),(1,3),(2,1),(2,2)) thanks in advance :) If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook Array3 = MakeArray(Array1, Array2,1) to give a 1-based Array3; Array3 = MakeArray(Array1, Array2,0) to give a 0-based Array3 Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cant pass array to excel from c++ using xloper structure | Excel Worksheet Functions | |||
union range | Excel Discussion (Misc queries) | |||
Help w/ Union Queries | Excel Discussion (Misc queries) | |||
Union question | Excel Programming | |||
VBA union of two ranges | Excel Programming |