https://bugs.documentfoundation.org/show_bug.cgi?id=158386
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Mike Kaganski <[email protected]> --- (In reply to Jeffry from comment #0) > you get a "Basic Syntax Error Code" that locks up the > program and Windows Task Manager is the only way to end the program. It doesn't lock up, it just shows it tens of times. Pressing Esc and holding it for a minute would dismiss all those message boxes, and finally allow you to use the document. The suggestion of m.a.riosv is best. The offending code is Function VLOOKUP2(ByRef values As range, ByRef matrix As range, column As Integer, Optional default As Variant = CVErr(xlErrNA)) As Variant where 'Optional default As Variant = CVErr(xlErrNA)' seems to be unsupported, we may not allow defaults to be defined by a function, only by a literal. Andreas, what do you think? -- You are receiving this mail because: You are the assignee for the bug.
