| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in a formula
How can I use a variable in a formula as shown below?
dim teller as integer (sample) teller = 6 ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[teller]C[-5]),"""",(RC[-4]+(-1*RC[-3])) this seems not to work can anyone help me? Thank you very much |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable in a formula
jobra,
ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[" & teller & "]C[-5]),"""",(RC[-4]+(-1*RC[-3])))" HTH, Bernie MS Excel MVP "jobra" wrote in message ... How can I use a variable in a formula as shown below? dim teller as integer (sample) teller = 6 ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[teller]C[-5]),"""",(RC[-4]+(-1*RC[-3])) this seems not to work can anyone help me? Thank you very much |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable in a formula
teller = 6
ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[" _ & teller & "]C[-5]),"""",(RC[-4]+(-1*RC[-3])) -- Regards, Tom Ogilvy "jobra" wrote in message ... How can I use a variable in a formula as shown below? dim teller as integer (sample) teller = 6 ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[teller]C[-5]),"""",(RC[-4]+(-1*RC[-3])) this seems not to work can anyone help me? Thank you very much |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable in a formula
Both Bernie & Tom thank you very much
"Tom Ogilvy" wrote: teller = 6 ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[" _ & teller & "]C[-5]),"""",(RC[-4]+(-1*RC[-3])) -- Regards, Tom Ogilvy "jobra" wrote in message ... How can I use a variable in a formula as shown below? dim teller as integer (sample) teller = 6 ActiveCell.FormulaR1C1 = _ "=IF(ISBLANK(R[teller]C[-5]),"""",(RC[-4]+(-1*RC[-3])) this seems not to work can anyone help me? Thank you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DDE formula with variable | Excel Worksheet Functions | |||
| Variable within a formula | Excel Worksheet Functions | |||
| use a variable in a formula | Excel Programming | |||
| variable in a formula | Excel Programming | |||
| Variable in a Formula | Excel Programming | |||
Hybrid Mode
