Syntax question

[bradyj7]

Hi,

How do you reference variables properly in formular1c1 function. I have some code below which is incorrect

Range("p2:p" & LastRow).FormulaR1C1 = "=((1080*9.81*sin(rc[-3])*"&l2&")-(9.81*1080*"&h&" *cos(rc[-3]))

Thanks

 

[Ruddles]

Well there's a closing quote missing and I think a closing parenthesis missing too. Did you mis-paste the line perhaps?

Apart from that, if your variables are called l2 and h, that looks okay... except I would put spaces around the & characters.

What makes you say it's incorrect?