Recalculating single cell

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

Hi Daniel,

Long time

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

 

[Guest]

Thanks - that's quite an impressive site!

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

 

[Guest]

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