Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
then AFAIK, you're out of luck, unless you haul out the magic wand &
give it a wave. the only thing you could do without using the clipboard is having a 3rd exact-size range that has each cell say =sum('sheet1!'v6+'sheet2!'v6) :) susan On May 23, 10:48 am, wrote: I should add that I don't want to do any cell by cell commands. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
"the only thing you could do"??!! Unless I misunderstand the spec, and
assuming that Rng1 and Rng2 are range names =Rng1+Rng2 array entered into a third range of the same size. Alan Beban Susan wrote: then AFAIK, you're out of luck, unless you haul out the magic wand & give it a wave. the only thing you could do without using the clipboard is having a 3rd exact-size range that has each cell say =sum('sheet1!'v6+'sheet2!'v6) :) susan On May 23, 10:48 am, wrote: I should add that I don't want to do any cell by cell commands. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
On May 23, 4:09 pm, Alan Beban <unavailable wrote:
"the only thing you could do"??!! Unless I misunderstand the spec, and assuming that Rng1 and Rng2 are range names =Rng1+Rng2 array entered into a third range of the same size. Alan Beban hence my preface Susan wrote: then AFAIK i'm glad you knew something i didn't that would help the OP. :) susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Block addition of ranges | Excel Programming | |||
Block addition of ranges | Excel Programming | |||
if/then block within another if/then block needs a loop | Excel Programming | |||
Addition? | Excel Discussion (Misc queries) | |||
row addition | Excel Worksheet Functions |