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.

for i = 1 to rng1.count

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

--
Regards,
Tom Ogilvy


"(E-Mail Removed)" wrote:

> 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.
>
>

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
--
Best wishes,

Jim


"(E-Mail Removed)" wrote:

> 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.
>
>