Hi Dave,

The scratch sheet I'm using have all blanks. In the US regional setting
your program runs successfully. In Dutch, I'm getting Run-time error
'1004': Application-defined or object-defined error.

BTW, what I implemented in my code is shown below. The quantities
within the IF expression are complex so I wanted to stay as close to
the original IF syntax as possible. The Replacement string operation
changes a target pattern "\," with either a ";" or "," depending on the
region.

sub test
Dim ListSep As String
Dim BackComma As String
BackComma = "\,"
ListSep = Application.International(xlListSeparator)

'****** y = Array("hello", "=if(x,0,0)") becomes ....

y = array("hello", _
Replace("=IF(x \, 0 \, 0 ", BackComma, ListSep)
end