Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 syntax
I have a need to place different formulas in different cells. I have an
integer C and string Col. C=50 Col=4. I need a formula like this: Range("K" & C + 3).Select ActiveCell.FormulaR1C1 = "=R[1-C]C[-10+Col]-5" I cannot get the correct syntax for using the variable in the R[] section. On the worksheet, this formuls should read =E4-5. Can someone help me with the syntax? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 syntax
Hi
try: ActiveCell.FormulaR1C1 = "=R[" & 1-C & "]C[" & -10+Col" & ]-5" -- Regards Frank Kabel Frankfurt, Germany "JCanyoneer" schrieb im Newsbeitrag ... I have a need to place different formulas in different cells. I have an integer C and string Col. C=50 Col=4. I need a formula like this: Range("K" & C + 3).Select ActiveCell.FormulaR1C1 = "=R[1-C]C[-10+Col]-5" I cannot get the correct syntax for using the variable in the R[] section. On the worksheet, this formuls should read =E4-5. Can someone help me with the syntax? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
activecell.formular1c1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
ActiveCell.FormulaR1C1 | Excel Programming |