- Feb 28, 2002
That's correct, Eric. It happens if the dynamic array formula doesn't generate a spilled range.One thing I've noticed is that occasionally the "dynamic array function" message does not appear when it is. Here's an example of a formula using FILTER that doesn't show the message:
The way how XL2BB knows if there is a dynamic array formula or not in the range is by checking if any of the cells in the selection has spilled or not in the code. If the array formula doesn't generate a spill then XL2BB doesn't know about it since it is not actually checking the function names.
(Note: If there is a workaround that I don't know for this, other than checking the function names, then I would love to hear it, so we can implement in XL2BB.)