Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 783
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 783
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cant pass array to excel from c++ using xloper structure malayhk Excel Worksheet Functions 0 November 4th 09 09:09 AM
union range Curt Excel Discussion (Misc queries) 9 April 20th 07 02:32 PM
Help w/ Union Queries Jenn Excel Discussion (Misc queries) 1 January 12th 05 01:07 AM
Union question ToddG Excel Programming 3 June 25th 04 07:57 PM
VBA union of two ranges s[_2_] Excel Programming 1 August 21st 03 02:18 AM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"