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