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

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

Hello Knut,
yes, as macro it works.

But as AddIn in C# nope.
It gives #NAME
as return

Frank

"Knut" schrieb im Newsbeitrag
...
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

OK, sorry dont know anything bout C#


knut
"Frank M. Walter" skrev i melding
...
Hello Knut,
yes, as macro it works.

But as AddIn in C# nope.
It gives #NAME
as return

Frank

"Knut" schrieb im Newsbeitrag
...
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