Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variables in RCs
Hi. I would like to have the following formula contain a variable if
possible. For instance, instead of having "RC[-10]", I would like to have "RC[-j]" where "j" is a variable. Is there a way to do this? ActiveCell.FormulaR1C1 = "=IF((RC[-10]+RC[-4])0,RC[-10]/(RC[-10]+RC[-4]),na())" Thanks, Mike. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Too Many Variables | Excel Worksheet Functions | |||
Three Variables | Excel Worksheet Functions | |||
Using variables . . . | Excel Discussion (Misc queries) | |||
DIm Variables | Excel Programming |