Valid Excel formula not working in macro

[Nikolette]

Greetings,

I'm trying to insert a formula (is valid; have used in an Excel sheet previously - also, have set Formulas - Calculation Options to Automatic) into a particular cell using the macro shown below, but I keep getting a "Compile error, Syntax error" as though there's something wrong with the formula. Are there certain formulas that cannot be used in a macro?

(Note: Although the Excel formula uses double quotation marks around the "Item" bit, I tried using single quotation marks (as in 'Item'), but get "Run time error '1004': Application-defined or object-defined error".)

Please Login or Register  to view this content.

Thanks in advance...

Nikolette

[jindon]

You need to add another double quotation when used in a formula

Please Login or Register  to view this content.

[Nikolette]

That worked! Thanks so much