I have this code, two 6x1 arrays and I want to combine them to make 6x2:
Can I combined it without using loop?
If its not possible, how do I combine it using loop.
These are only part of my logic. What I want is to combine multiple arrays,
say I have, 6x1,6x2,6x3 etc. and combined into one 2D array 6x6.
Code:
Sub CombineArray()
a = Evaluate("INDEX(ABS(A1:A6),)+ INDEX(ABS(B1:B6),)")
b = Evaluate("INDEX(ABS(C1:C6),)+ INDEX(ABS(D1:D6),)")
End Sub
Can I combined it without using loop?
If its not possible, how do I combine it using loop.
These are only part of my logic. What I want is to combine multiple arrays,
say I have, 6x1,6x2,6x3 etc. and combined into one 2D array 6x6.