| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recalculating single cell
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recalculating single cell
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recalculating single cell
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recalculating single cell
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recalculating single cell
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop specific cell from recalculating? | Excel Worksheet Functions | |||
| please help! Linking a picture to a cell and recalculating automatically | Excel Discussion (Misc queries) | |||
| cursor tracks / highlights recalculating cell? | Excel Discussion (Misc queries) | |||
| cell/range with formula not recalculating | Excel Worksheet Functions | |||
| Recalculating cell | Excel Programming | |||
Linear Mode
