Too easy. I used to know that.

Thanks,
Tim C

"Bob Phillips" wrote in message
...
Tim,

That's because you've said use R1C1 notation, and then passed it A1
notation, so it thinks A1 is a string.

Try

Cells(Selection.Row, 3).FormulaR1C1 =
"=TRIM(SUBSTITUTE(RC[-2],R3C1,""""))"

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Tim C" wrote in message
...
Excel 2003 Beta

What is the syntax for including an absolute reference within R1C1
notation?

My latest attempt:

Cells(Selection.Row, 3).FormulaR1C1 =
"=TRIM(SUBSTITUTE(RC[-2],A3,""""))"

But Excel adds single quotes around the A3.

Thanks,
Tim C