I am using vb.net to populate an excel sheet fine...
But when using:
.ActiveCell.FormulaR1C1 = "=MIN(C" & intFirstYellow & ":C" & intLastYellow & ")"

to place a formula i.e. =MIN(C5:C7)

does not work accurately, it place =MIN($E:$F) instead.

Can you see why?
Thanks