View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jobra jobra is offline
external usenet poster
 
Posts: 13
Default 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