Here's a related question. I'm trying to use the value of a variable i
an equation. The variable Slope is a double precision value resultin
from a LINEST equation performed earlier. I'm trying to set up the VB
code so that the Excel formula looks like =(B1*Slope)-C1 where Slope i
that value calculated earlier. I've tried a few differen
combinations, but with no luck.

I'd imagine it's something like this, but it's not working
Code
-------------------
ActiveCell.FormulaR1C1 = "=(RC[-2]*" & Slope & ")-RC[-1]
-------------------


--
Message posted from http://www.ExcelForum.com