ActiveCell.FormulaR1C1 Regional Setting influence?

**adyan76** · 09-01-2009, 07:48 AM

HI Friends,

I wonder, whether ActiveCell.FormulaR1C1 has depends on regional setting of PC. My PC language is english and the following statement works fine

PHP Code:


ActiveCell.FormulaR1C1 = "=" & ActiveCell.Value & " - " & currentvalue & ""

and one of my friend has german language for the Pc and the same statement throughs an error.
What could be reason behind this?
I appreciate your advises.
Thanks

**Richard Schollar** · 09-01-2009, 08:12 AM

Very hard to say without knowing what the value of the Activecell and the variable currentvalue is at the time of the error.

**adyan76** · 09-01-2009, 08:54 AM

I have found that for the two variable values like 8 and 4 the code works, but for values like 9,88 and 7,22 the code does not work. On the other side for values 9.88 and 7.22 the code works fine.
The question arrises How can I update my code that it should work for PCs with different settings.

**Richard Schollar** · 09-01-2009, 10:13 AM

That's because of the system separators. Try using the FormulaR1C1Local property instead:

Please Login or Register  to view this content.

Richard

**adyan76** · 09-02-2009, 03:49 AM

Originally Posted by RichardSchollar

That's because of the system separators. Try using the FormulaR1C1Local property instead:

Please Login or Register  to view this content.

Richard

Sorry for late response
I tried with your suggestion for 9,88 and 7,22 and the result for subtraction is 266. I think it does not work in this way.

**Richard Schollar** · 09-02-2009, 05:19 AM

so what did it do using FormulaR1C1Local? Did you get an error return from the formula? Did VBA debug at that line and if so what was the error code?

**adyan76** · 09-02-2009, 06:03 AM

Originally Posted by RichardSchollar

so what did it do using FormulaR1C1Local? Did you get an error return from the formula? Did VBA debug at that line and if so what was the error code?

there is no error thrown by the compiler but the subtraction of two values give me result as 266, which is wrong, right would be 9,88 - 7,22 = 2,66.

**romperstomper** · 09-02-2009, 06:46 AM

How is currentvalue declared and assigned a value?

**adyan76** · 09-02-2009, 08:28 AM

I found the solution without changing anything in the system settings

PHP Code:


If Application.DecimalSeparator = "," Then 
 
ActiveSheet.UsedRange.Select 
 
Application.DecimalSeparator = "." 
Application.ThousandsSeparator = "," 
Application.UseSystemSeparators = False 
 
ElseIf Application.DecimalSeparator = "," And Application.ThousandsSeparator = "," Then 
 
 
 
 
End If

Thanks for your support