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