Array of formulas (regional difference)
'Following works for both US and Dutch
x = "=if(x,0,0)"
y = Array("hello", "=w")
' Following works for US, but not in Dutch, why?
y = Array("hello", "=if(x,0,0)")
The default argument separator for Dutch regional settings is ";"
For US the comma is used.
Try the following statement
y = Array("hello", "=if(x;0;0)")
regards,
Erik
|