Table of contents
TOC
Collapse the table of content
Expand the table of content

Expression too complex (Error 16)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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 (in Windows) or HELP (on the Macintosh).

© 2018 Microsoft