Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Relative cell references | Excel Programming | |||
relative cell references | Excel Programming | |||
how to use relative cell references with solver | Excel Programming | |||
Relative Cell References in Macros | Excel Programming |