FormulaLocal in Conditional Formatting

[bulina2k]

Hi there!

I wrote a piece of code for somebody that has as formula separator the coma character (,) so on his computer you wold write as a formula:
=AND($B$3>$B$4,$C$3>$C$4)
but on my computer the system separator is the semicolon ( ; ) so the same formula to work it will have to written like this"
=AND($B$3>$B$4;$C$3>$C$4)
Now my problem is that I'm trying to apply conditional formatting using VBA and I have to replace that separator with the system's separator because FormatConditions.Add does not support FormulaLocal. Is there a way I can find the system separator?

...
myformula = "=AND($B$3>$B$4,$C$3>$C$4)"
rng.FormatConditions.Add xlExpression, Formula1:=myformula 
rng.FormatConditions(1).Font.Bold = True
rng.FormatConditions(1).Font.Italic = True
...

[bulina2k]

Got it! It was the ListSeparator I was after! Thanks anyway!
For whom it might help:

Application.International(xlListSeparator)