Hi Chip,

Thank you. The other worked also.

Can you help me with not being able to get an e-mail response? I think I
have checked all the things I need to check to be able to get a notification,
but I am still not.

Thanks,
--
David


"Chip Pearson" wrote:


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

should be

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

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Fri, 9 Apr 2010 11:26:01 -0700, 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,
.