I bet you're using .formulaR1C1, but you're creating the formula using A1
reference style.

Maybe you can use .formula (or actually change the formula so that it uses R1C1
reference style).

somecell.formulaR1C1 = "=...."
becomes
somecell.formula = "=...."


Mark Lucas wrote:

I am attempting to use a macro to write a formula in to a blank cell. When
the formula is written, the cell reference in the formula has apostrophes
around it so it won't function. I'm sure there is a syntax step I'm missing.
Can someone help??

--

Dave Peterson