Using formula in code...Part 3!

A

Alan M

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?
 
D

Dave Peterson

This was answered in the other thread.

Alan said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top