I have this code:
Is this really not possible?Or am I missing something?
Or else I really have to do it using loop.
Code:
Sub AddArray()
Dim A1 As Variant
Dim A2 As Variant
A1 = Range("A2:A6").Value
A2 = Range("B2:B6").Value
Range("C2:C6").Value = A1 + A2
End Sub
Is this really not possible?Or am I missing something?
Or else I really have to do it using loop.