Using formula in code...Part 3!

G

Guest

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?
Click to expand...
 

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

Similar Threads

Using formula in code....Part 2! 7
Macro autofills formula when a cell value is changed 4
Formula in macro gives "Run-time error '1004':" 1
VLOOKUP with VB 1
Problem with line of code / syntax 4
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1
VBA formula question 8
Why are the two codes below not getting the right formula for myworksheet event change formula? 2

Top