https://bugs.documentfoundation.org/show_bug.cgi?id=149151
e...@helpidea.net changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |e...@helpidea.net --- Comment #3 from e...@helpidea.net --- It seems that IIF evaluate both values before give a return value. In PitonYack pag 77 : "The IIf (“Immediate If”) function returns one of two values based on a conditional expression.". May be array is not a valid value. Workaround : Sub TestA Dim i as Long, arr, a, b i = 0 a = Array() b = Array(0) arr = b : If i = 0 Then arr = a ' arr = Iif(i = 0, a, b) End Sub -- You are receiving this mail because: You are the assignee for the bug.