Solved: SUM Formula

[Giri]

Hi Guys,

Could someone please let me know how to write the formula to SUM two ranges when the two ranges have been defined as variables of type range?

E.g
[VBA]
Dim rangeOne as Range
Dim rangeTwo as Range

Set rangeOne = Range("A1")
Set rangeTwo = Range("A5")
[/VBA]

So if I wanted to use "rangeOne" and "rangeTwo" in the SUM formula, how would that be written?

[VBA]
Range("B1").Formula = ????
[/VBA]

Thank you!

Kind Regards,

Giri

[Bob Phillips]

[vba]

Range("B1").Formula = "=" & rangeone.address & "+" & rangetwo.address[/vba]

[Giri]

Oops Sorry... should have been more clear.

I meant, summing "A1:A5".

Thanks xld.

Kind Regards,

Giri

[Aussiebear]

Range ("B1").Formula = "=Sum" & Range0ne.Address & "+" & Rangetwo.Address

[Giri]

Thanks Aussie Bear.

For some reason I am getting "Run Time Error 1004: Application Defined Error"

This is the code I have. I'm not sure what I am doing wrong because all the variables seem to be referenced correctly.

[VBA]
Giri.Offset(-2, 0).Formula = "=SUM" & topRed.Address & "+" & redEnd.Address
[/VBA]

Any ideas what RunTime Error 1004 refers to?

Thanks.

Kind Regards,

Giri

[Bob Phillips]

[vba]

Dim rangeOne As Range
Dim rangeTwo As Range

Set rangeOne = Range("A1")
Set rangeTwo = Range("A5")

Range("B1").Formula = "=SUM(" & Range(rangeOne, rangeTwo).Address & ")"
[/vba]

[Giri]

Perfect, xld!

Thank you!

Kind Regards,

Giri