Entering a formula with macro into cell

[bobo1000]

Dear all,
i tried this now for some time but cannot figure it out. I want to enter the following formula in Cell C7:

Please Login or Register  to view this content.

however I alwys get a runtime error 1004: 'application-defined or object-defined error'.

could anyone tell me what i am doind wrong? if I leave the equal sign, then the text is entered in the cell.....


thanks everyone!

[event21]

Hi -

Even if you take off the equal sign it will throws an error, check your spelling;

Please Login or Register  to view this content.

Regards,
event

[Pete_UK]

...
although I'm not sure why you are using semi-colons to separate parameters if you are based in London.

Hope this helps.

Pete

[JosephP]

the formula property expects u.s. delimiters

Please Login or Register  to view this content.

or use formulalocal

Please Login or Register  to view this content.

[bobo1000]

Thanks a lot! the formulalocal thing worked well. Can you maybe tell me what the difference is with the Formulalocal?

Regarding the semicolons, I am using an englisch excel version but currently I am based in germany. my excel always uses semicolons as separators.

and sorry regarding the spelling error. that must have happend while typing it in here. in the original code there was no typo. sry.
@all thanks a lot for your help!

[JosephP]

formulalocal expects a formula the way you would enter it in a sheet but formula expects us-english format

[event21]

Hi -

Is .value works in Germany too? Can you advise?

Please Login or Register  to view this content.

Regards,
event