View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_4_] Alan Beban[_4_] is offline
external usenet poster
 
Posts: 171
Default Combining two arrays

The freely downloadable file at http://home.pacbell.net/beban contains
at least a couple of functions that might be helpful in combining
arrays, depending on exactly what you're trying to accomplish. They do
usually involve looping, but that looping is pre-written. If you have
any interest in that, you might post back with some details. E.g., are
the arrays the same sizes? Same number of rows, different number of
columns? Vice versa? Are they of the same variable type?

Alan Beban

dan wrote:
Is there an easier way to append one array on to another?

I know I can a loop from lbound to ubound of an array putting it in ubound+1 with the appropriate redims but I was hoping for something shorter.

Also while I am here is there an internal array sort function? and if so can it handle multidimensional arrays?