View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Erik Creyghton[_3_] Erik Creyghton[_3_] is offline
external usenet poster
 
Posts: 6
Default 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