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

Non Refreshing/Recalculating Cell ??
 

Hi,

probably the cell is formated as "Text"
or tools, options, view, uncheck formulas

Regards,
Ivan

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