Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
for i = 1 to rng1.count
rng2(i) = rng2(i) + rng1(i) Next -- Regards, Tom Ogilvy " 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
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 " 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if/then block within another if/then block needs a loop | Excel Programming | |||
Addition? | Excel Discussion (Misc queries) | |||
Sum vs. Addition | Excel Programming | |||
addition | New Users to Excel | |||
row addition | Excel Worksheet Functions |