Block addition of ranges

[chrisquayle]

I am trying to achieve the following with a vba macro:

Add the values of Rng1 on top of the existing values in Rng2. Rng1 &
Rng2 are the same dimensions. It can be done by copying Rng1 and doing
a PasteSpecial values add command to Rng2. However, it is a
requirement that this macro does not use the clip board.

Would really appreciate any ideas.

 

[Guest]

for i = 1 to rng1.count

rng2(i) = rng2(i) + rng1(i)
Next

 

[Guest]

One idea.

Sub TEST()
Range("D3") = Range("A50").Value
'repeat for each cell involved
'or set up a loop to cover the cells
End Sub