Visual Basic for Applications Reference

  • Article

Expression too complex (Error 16)

See Also

The number of subexpressions allowed in a floating-point expression varies among platforms. For example, on 32-bit Microsoft Windows operating systems, the limit is 8 levels of nested floating-point expressions. This error has the following cause and solution:

  • A floating-point expression contains too many nested subexpressions.

    Break the expression into as many separate expressions as necessary to prevent the error from occurring.

Note   In earlier versions of Visual Basic, Error 16 was "String expression too complex." That error condition can no longer occur. However, if you have early code that traps and handles that error, you should remove it to prevent confusion with this new error.

For additional information, select the item in question and press F1.