| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| 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 | |||
Hybrid Mode
