View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ken4capitola ken4capitola is offline
external usenet poster
 
Posts: 13
Default Array of formulas (regional difference)

Following fragment works when the region is set for US, but fails for
Dutch

Dim x As Range
Dim y As Range
Dim w As Range
Set w = Range("AH4")
Set x = Range("AH5")
Set y = Range("AG1:AH1")

'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)")