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

Hi,

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

Regards,
Ivan

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