Recalculating single cell

[Daniel Bonallack]

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

[Jim Thomlinson]

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
>

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
> 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
>

[Daniel Bonallack]

Thanks - that's quite an impressive site!

"Jim Thomlinson" wrote:

> 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
> >

[Daniel Bonallack]

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" <[email protected]> wrote in
> message news:[email protected]...
> > 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
> >
>
>
>