Array +fonction+vba

[hoareau]

Hello

Array +fonction+vba

That is to say 2 arrays Tab1(4) and Tab2(10)

I would like Tab1+Tab2 = tab3(14) and knowledge if it is posible
to apply a function to an array

Ex: Aplication.Worshetfunction.Average(Tab3)
Average is just an example not theright function


Different need to know the number of element in Tab3 without loops


Thank you

 

[hoareau]

ex:

Array1 (1,2,3,4)

Array2 (1,2,5,6,7,8,9,10,11,12)

Array1+Array2=Array3


Array3(1,2,1,2,3,4,5,6,7,8,9,10,11,12)

12 different number