Using formula in code...Part 3!
 

Following on from Parts 2 and 1.......!!! See previous questions of the same
title.

Bob Phillips provided me with the following code:

Range(Cells(1, 17), Cells(LastRow, 17)).FormulaR1C1 = _
"=MID(RC[-2],FIND(""."",RC[-2],1)-1,3)"


This works fine but instead of returning a resulting value...it places the
formula itself in the target range. I.e the cells contain the written formula
expression rather than the result of the calculation described by that
expression.
Anyone know why please?

Using formula in code...Part 3!
 

This was answered in the other thread.

Alan M wrote:

Following on from Parts 2 and 1.......!!! See previous questions of the same
title.

Bob Phillips provided me with the following code:

Range(Cells(1, 17), Cells(LastRow, 17)).FormulaR1C1 = _
"=MID(RC[-2],FIND(""."",RC[-2],1)-1,3)"

This works fine but instead of returning a resulting value...it places the
formula itself in the target range. I.e the cells contain the written formula
expression rather than the result of the calculation described by that
expression.
Anyone know why please?

--

Dave Peterson