I think what you're looking for is:

ActiveCell.FormulaR1C1 = "=+RC[-1]+R[14]C[-1]+" & z

I seem to recall reading in a numbe of posts here that the
reply-notification feature isn't working. You're not the only one.

"David" wrote:

Hello Group,

I have a formula that is added via code:
ActiveCell.FormulaR1C1 = "=+RC[-1]+R[14]C[-1]"
and I would like to reatin the formula and add a constant to it. z=1
I tried:
ActiveCell.FormulaR1C1 = "=+RC[-1]+R[14]C[-1]" + z
but this failed. I am not sure how to accomplish adding the variable amount
and retaining the code.

Another unrelated question. I am having trouble getting responses to these
questions via e-mail alert. I have been into the preferences area and it
appears set up correctly. I have also checked the check box in this window. I
also click the "Notify me of relpies" in the main window where you start with
the "New" question, suggestion or comment. But I still fail to get an e-mail.

Thanks,
--
David