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