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?
Bookmarks