Adding values stored at relative cell references
 

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.

Adding values stored at relative cell references
 

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

"tc" wrote:

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.