Array Formula (i.e., CSE) UDFs Called Twice

18 views Asked by At

We've noticed that when the user enters an array formula (the legacy CSE formulas) for a UDF, the UDF is called twice. This does not happen with dynamic arrays (Excel 365+). This "double call" happens in Excel 2019 and 365.

Because this double call wreaks havoc with our validation code, we'd like to guard against it. Is there a way to detect an incoming CSE formula?

0

There are 0 answers