Absolute reference in R1C1 notation
 

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

Absolute reference in R1C1 notation
 

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

Absolute reference in R1C1 notation
 

Tim,

You are instructing Excel to use R1C1 notation and it doesn't recognize A3
as a cell reference. If it is one that use R3C1 instead. If A3 is text
than use ""A3""

As for Absolute Reference R3C3 is absolute R[3]C[3] is relative
The difference is in the brackets.

steve

"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