VBA error 16:  Expression too complex


Expression has too many nested functions. 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. A floating-point expression that contains too many nested subexpressions will throw this error.


This error has the following cause and solution:

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

Interested in learning new skills?