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
|