View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Combining 2 arrays side-by-side

Or dump both arrays to a sheet and then make a new array from the combined
ranges.

RBS

"Bob" wrote in message
...
I have 2, two-dimensional Variant arrays. Both arrays have the same number
of "rows". However, each array has a different number of "columns".

Is it possible to combine both arrays in such a way that the 2nd array is
appended to the right (rather than to the bottom) of the 1st array?

I have looked at both Beban's and Pearson's excellent (and indispensable)
UDFs, but unless I'm missing something, none of the UDFs appear to
accomplish
what I'm trying to do.

Any guidance in this area would be greatly appreciated. Thanks.