'Application.Evaluate("<<positive number>>") throws application defined error

So in one of my projects I have an evaluator callback which offers me lambda-like syntax for dealing with arrays:

fMitPCInt = Mitigations.Filter(cbEqn, Eqn("$_::isInternal")).Map(cbMit, Eqn("$_.GetEFI(""" & sSeverityInt & """)"))

This essentially generates a callback which calls Application.Evaluate (innefficient I know but it's a nice syntax sugar).

Long and short of it is in Excel365 Application.Evaluate("1") throws an error. From testing I found the following:

Application.Evaluate("3")   'throws error
Application.Evaluate("2")   'throws error
Application.Evaluate("1")   'throws error
Application.Evaluate("0")   'works
Application.Evaluate("-1")  'works
Application.Evaluate("-2")  'works
Application.Evaluate("-3")  'works
Application.Evaluate("1+0") 'works

So essentially, Application.Evaluate just doesn't work for positive numbers in Excel365.

How can we get around this problem?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source