| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine Myvalue with formula
Hi,
ActiveCell.FormulaR1C1 = "=RC[-9]+15.07" I have this formula. the value 15.07 does change and i tried: ActiveCell.FormulaR1C1 = "=RC[-9]+Myvalue" but it doesn't work. How? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine Myvalue with formula
ActiveCell.FormulaR1C1 = "=RC[-9]+" & Myvalue
"Helmut" wrote: Hi, ActiveCell.FormulaR1C1 = "=RC[-9]+15.07" I have this formula. the value 15.07 does change and i tried: ActiveCell.FormulaR1C1 = "=RC[-9]+Myvalue" but it doesn't work. How? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine a VLOOKUP formula and a NETWORKDAYS formula? | Excel Worksheet Functions | |||
| How do I combine If and AND Formula | Excel Worksheet Functions | |||
| Using MyValue in SaveAs Fname | Excel Programming | |||
| How do I combine an if and min formula? | Excel Worksheet Functions | |||
| MyValue | Excel Programming | |||
Linear Mode
