Adding values stored at relative cell references

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tc - 17 May 2008 12:42 GMT

hi. i need to add values which are stored in cells with relative cell
references. for eg. ActiveCell.FormulaR1C1 = "=Sum(0.15*(RC[-3]-RC[-6])
+ H12" . Is this possible? and if it is, i would also like to know how
to change the reference to a row above or below. thanks in advance.

Reply to this Message

Joel - 17 May 2008 21:11 GMT

Because you are using FormulaR1C1 everythiing has to use R1C1 format. R1C1
formating doesn't need to use relative referencing. Change H12 to R12C8.

> hi. i need to add values which are stored in cells with relative cell
> references. for eg. ActiveCell.FormulaR1C1 = "=Sum(0.15*(RC[-3]-RC[-6])
> + H12" . Is this possible? and if it is, i would also like to know how
> to change the reference to a row above or below. thanks in advance.

Reply to this Message