Search notes:

Excel functions: Separating arguments with semicolon or commas

If arguments in an Excel worksheet functions are to be separated by semicolons or commas is determined by the Windows setting List separator and can be queried with VBA like so:
application.international(xlListSeparator)
When using Visual Basic for Applications to assign formulas to a range's .formula property, the separator is always a comma.
Unfortunately, this assertion does not seem be be true for the properties formula1 and formula2 of the formatCondition object.

Index