I think you might be wrong, tried this with a Norwegian copy of Excel 2003:

Sub Test1()
ActiveCell.Value2 = "=Count(A1:A20)"
End Sub

B1 was the active cell and the formula in B1 became: =ANTALL(A1:A20) which
is Norwegian equvivalent to =COUNT(A1:A20), and the formula works.

BTW: when you insert a formula with VBA should you not use
ActiveCell.Formula = "=Count(A1:A20)" ?


HTH
knut

"Frank M. Walter" skrev i melding
...
Hello,

It is possible to put formula to active cell programaticaly.
But, I have a problem with formula names.

Here a snipped:

activeCell.Value2 = "=Count(A1:A20)";

This does work only with english excel.

Is there any posibility to put formulas in international name ?
I would like to make my AddIn working not depending of OS.

Thanks

Frank