Adding values stored at relative cell references

T

tc

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.
 
J

Joel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Geometric progression in VBA 10
Dynamic add formula 2
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 2
Insert Formula in cells from VBA 2
Referring to a relative cell within a function 5
macro to copy rows that contain a cell with a certain number 3
relatetive reference-to perform a series of cal and return result 2
Macro autofills formula when a cell value is changed 4

Top