Everything you ever wanted to know about Excel Calculation but were affraid
to ask is on this site

http://www.decisionmodels.com/calcsecrets.htm

HTH

"Daniel Bonallack" wrote:

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