FormulaR1C1 returning nothing when using a variable

[Zem32619]

Hi All.

I have a code that works perfectly fine for users with the US excel and windows setting. I'm stuck why FormulaR1C1 doesn't work as it should when ran in a German setting.
Here is the line of code that works for US setting.

Range("L2").FormulaR1C1 = "=(1-(RC[14])- " & ACoS & " ))*RC[-1]"

But it returns nothing, as in empty when ran in a German setting. I'm thinking if it is the variable thing "ACoS".

Would really appreciate any help. Thank you so much in advance.

 

[gordsky]

Does replacing FormulaR1C1 with FormulaR1C1LOCAL make any difference?

 

[Zem32619]

Does replacing FormulaR1C1 with FormulaR1C1LOCAL make any difference?

HI Gordsky.

Thanks for your quick reply, but I tried it still the same.

 

[Michael M]

I might be misunderstanding, but there doesn't seem to be a cell reference for Acos...shouldn't it be Acos(cell reference)

 

[gordsky]

Can you enter these two formulas into two cells (on the German version) and tell me what they come back with

=LEFT(ADDRESS(1;1;1;0);1)

=MID(ADDRESS(1;1;1;0);3;1)

 

[Zem32619]

I might be misunderstanding, but there doesn't seem to be a cell reference for Acos...shouldn't it be Acos(cell reference)

HI Michael,

ACoS is a variable.

 

[Zem32619]

Can you enter these two formulas into two cells (on the German version) and tell me what they come back with

=LEFT(ADDRESS(1;1;1;0);1)

=MID(ADDRESS(1;1;1;0);3;1)

=LEFT(ADDRESS(1;1;1;0);1) = R
=MID(ADDRESS(1;1;1;0);3;1) = C

 

[Zem32619]

Hi All.

I have a code that works perfectly fine for users with the US excel and windows setting. I'm stuck why FormulaR1C1 doesn't work as it should when ran in a German setting.
Here is the line of code that works for US setting.

Range("L2").FormulaR1C1 = "=(1-(RC[14])- " & ACoS & " ))*RC[-1]"

But it returns nothing, as in empty when ran in a German setting. I'm thinking if it is the variable thing "ACoS".

Would really appreciate any help. Thank you so much in advance.

Also, if I put a fixed number in the formula, say 30%, instead of variable "ACoS", it works as it should.

 

[Michael M]

I think you need to rename the variable...ACos is a native function of Excel, so shouldn't be used.
So I'm guessing the code is misreading it as an Excel function
"The ACOS function returns the inverse cosine of a number. The function is the inverse of COS and expects input in the range from -1 to 1."

 

[Zem32619]

I think you need to rename the variable...ACos is a native function of Excel, so shouldn't be used.
So I'm guessing the code is misreading it as an Excel function
"The ACOS function returns the inverse cosine of a number. The function is the inverse of COS and expects input in the range from -1 to 1."

HI Michael.

Thanks for your reply. I tried changing the variable name and it gives me the same problem.