Hi,

In a spreadsheet I insert a very simple formula :

Range("I1").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(A:A,""*"")"
Range("I2").Select

Cell I1 gives an error #NAME?, but when selecting this cell, put
cursor after last char and press enter, the right value appears ! So i
did NOT modify it only place cursor and hit enter ...

Any thoughts ?

-ben