combine Myvalue with formula

  • Thread starter Thread starter Helmut
  • Start date Start date
H

Helmut

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?
 
You must log in or register to reply here.

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

Geometric progression in VBA 10
"=TEXT(RC[-1],"MMM")" 4
Dynamic add formula 2
Link Cells & Paste Special Macro 7
Data samples 3
macro to copy rows that contain a cell with a certain number 2
Help with my VBA and formula 8
Write to intersect of a row and column 7

Back
Top