| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Non Refreshing/Recalculating Cell ??
I have a cell that is being calculated via VB, and it's not actually
calculating anything, just showing the formula. If i manually type in the formula, the same thing happens. Is there some setting/format that i'm missing? here's the code: For nRow = 3 To 3 Step 1 Range("C4").Select ActiveCell.FormulaR1C1 = _ "='Sheet1'!C" & nRow Next nRow The code manually typed in is: ='s-matched to banks'!C3 Neither is working. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Non Refreshing/Recalculating Cell ??
Hi,
probably the cell is formated as "Text" or tools, options, view, uncheck formulas Regards, Ivan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Non Refreshing/Recalculating Cell ??
Brilliant! It was labeled as "Text". Thanks so much!
"Ivan Raiminius" wrote: Hi, probably the cell is formated as "Text" or tools, options, view, uncheck formulas Regards, Ivan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop specific cell from recalculating? | Excel Worksheet Functions | |||
| Odd behavior...recalculating, refreshing? | Excel Discussion (Misc queries) | |||
| Preventing only one cell from recalculating | Excel Programming | |||
| Recalculating single cell | Excel Programming | |||
| Recalculating cell | Excel Programming | |||
Hybrid Mode
