| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative references in formulas
I am aware of the basic usage of relative references in establishing a
formula. For example to sum a column of cells relative to a given cell the following can be used: ActiveCell.FormulaR1C1="=sum(R[-5]C[-2]:R[-1]C[-2])" However, since the formula is a string, it is not possible to replace, for instance, -5 with a variable. Is there a straightforward way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas with relative references | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
| Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
| Confused about relative references in named formulas | Excel Worksheet Functions | |||
Threaded Mode
