Add range to a span of cells

[Huy Le]

Hi ,

I''ve looked at the example about Namming the range. It is more like one name Range for a Cell, is the any way I can set for a span of cells.

for example

Range1 = "C1:C10"
Range2 = "D1:D10"
Range3 = "E1:E10"
then late on use

Range3 = Range1 + Range2 (this is just an example, the syntax might be different)

internally, the values gonna be something like this

Range3[1] = Range1[1] + Range2[1]
...
...
...
...
...
Range3[10] = Range1[10] + Range2[10]

Thank you.

Huy Le...

[Administrator]

I assume you are looking at some private build as Named Ranged support has not been released publicly yet, is this correct?

Anyway, you cannot do

    
 Range3 = Range1 + Range2  

but you can have a formula in a cell that reads

 
      = Sum(Range1) + Sum(Range2)

when you define range1 = "C1:C10" and range2 = "D1:D10"