Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
activecell.formular1c1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
ActiveCell.FormulaR1C1 | Excel Programming |