Hi Bob
How's things?
You may not get this at this late date - rSales is just a range name for a
single cell - I might just have well said Range("A1").calculate.

Daniel


"Bob Phillips" wrote:

Hi Daniel,

Long time :-)

What is rSales, is it a variable, or a workbook name? And what is its value?

--
HTH

Bob Phillips

"Daniel Bonallack" wrote in
message ...
I'm trying to recalculate a single cell with code on a Excel sheet.

My code is:
Range("rSales").calculate

The sheet is unprotected.
The error message is: Calculate method of Range class failed

What am I doing wrong?
Thanks very much
Daniel Bonallack