Put formula in cell
 

I sometimes get the value instead of the formula in O2. What have I missed?

Range("O2").Formula = "=SUM(Q13:R13)"

Thanks

Put formula in cell
 

There is nothing wrong with that, so did this give a value?

When you say a value, do you mean the result of the SUM, or the text
=SUM(Q13:R13)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"booshi" wrote in message
...
I sometimes get the value instead of the formula in O2. What have I
missed?

Range("O2").Formula = "=SUM(Q13:R13)"

Thanks

Put formula in cell
 

Thanks for reply.
I want to display the value in cell O2 but keep the formula in the formula
input row of O2. (In other words, just like manually entering a formula in
the formula input row of O2 and get the sum in cell O2.)
I found that if I arbitrary enter another formula in O2 and then run the
subroutine, I can keep the formula. so ~ Problem solved.

But during the experiment, I also found that the formula input row of
certain cells behave differently, (even the cell format are same, cells are
empty) . Some shows value but some shows formula!

"Bob Phillips" ¦b¶l¥ó
¤¤¼¶¼g...
There is nothing wrong with that, so did this give a value?

When you say a value, do you mean the result of the SUM, or the text
=SUM(Q13:R13)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"booshi" wrote in message
...
I sometimes get the value instead of the formula in O2. What have I
missed?

Range("O2").Formula = "=SUM(Q13:R13)"

Thanks