combine Myvalue with formula

's Computer Specifications

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?

's Computer Specifications

ActiveCell.FormulaR1C1 = "=RC[-9]+" & Myvalue

"Helmut" wrote:

> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I combine a VLOOKUP formula and a NETWORKDAYS formula?	Tracy	Microsoft Excel Worksheet Functions	2	15th Oct 2009 04:14 PM
How do I combine If and AND Formula	Nicole	Microsoft Excel Worksheet Functions	5	20th Feb 2008 03:06 AM
Set MyValue	=?Utf-8?B?Ym9kaGlzYXR2YW9mYm9vZ2ll?=	Microsoft Access VBA Modules	1	8th Aug 2007 06:14 PM
Using MyValue in SaveAs Fname	=?Utf-8?B?SGVsbXV0?=	Microsoft Excel Programming	3	3rd Jul 2007 01:36 PM
MyValue	=?Utf-8?B?U3RlcGhhbmllSA==?=	Microsoft Excel Programming	3	27th Oct 2004 10:14 PM