ExcelBanter - combine Myvalue with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - combine Myvalue with formula (https://www.excelbanter.com/excel-programming/409307-combine-myvalue-formula.html)

Helmut

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?

joel

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?

All times are GMT +1. The time now is 05:25 PM.