How to specify an absolute cell ref in FormulaR1C1
 

I need to specify an absolute cell reference in the following. The absolute
required is needed instead of R[-4]C[-3] and is E$9$. What is the correct
syntax please?

rng.FormulaR1C1 = "=+R[24]C[-1]/R[-4]C[-3]*RC[-5]"

Terry

How to specify an absolute cell ref in FormulaR1C1
 

R9C5


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Terry" wrote in message
...
I need to specify an absolute cell reference in the following. The absolute
required is needed instead of R[-4]C[-3] and is E$9$. What is the correct
syntax please?

rng.FormulaR1C1 = "=+R[24]C[-1]/R[-4]C[-3]*RC[-5]"

Terry