Adding values stored at relative cell references

  • Thread starter Thread starter tc
  • Start date Start date
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.
 
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
Insert Formula in cells from VBA 2
relatetive reference-to perform a series of cal and return result 2
Referring to a relative cell within a function 5
macro to copy rows that contain a cell with a certain number 2
Macro does not populate later rows 2
Data samples 3

Back
Top