FormulaR1C1 Error

[wolis]

Dear Excel experts,
I am currently strugling with this problem: I just need to insert a simple formula into an excel cell, but it does not seem to want to work.
The code:

Please Login or Register  to view this content.

The second line gets highlighted and I get Run-time error '1004' (Application-defined or object-defined error)
To me the formula seems correct so what could possibly be the problem?

[mohd9876]

replace the semi colons with commas:

Please Login or Register  to view this content.

[wolis]

Thanks mohd9876
Is this always used in VBA, or does it depend on my settings?

[JosephP]

formular1c1 always uses US settings. formular1c1Local uses your settings.