Hi,
My Windows country settings use a comma for decimal separation and a period for thousand separation.
When I use this code in VBA:
Range("A2").Formula = "=0.9"
I use a period in VBA. In excel translates it as =0,9
However, when I use this code:
Range("A2").FormatConditions.Add Type:=xlCellValue, Operator:=xlNotBetween, Formula1:="=0,9", Formula2:="=1,1"
I have to use a comma, or I will get a run-time error '5' : "Invalid procedure, call or argument"
How can I make my workbook work in European AND US settings in Windows?
Thanks for helping me out here...
Bookmarks