How to specify an absolute cell ref in FormulaR1C1

T

Terry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to code in excel vba 2007 using absolute refernce for cells 1
Absolute reference 2
absolute reference r1c1 code 1
addressing type in FormulaR1C1 1
VBA r1c1 absolute previous row in formula 3
Macro autofills formula when a cell value is changed 4
display calculation next row 5
Auto-calculate after a cell is filled in - Macro is looping!!! 2

Top