Feb 25 2021 02:11 PM
I used to be able to name several cells of data in a row, use the named row in a formula, then add in extra details into specific cells. This now leads to a #spill! error as the named row now appear to be a dynamic array.
How do I go back to the old way? ie static array?
Feb 26 2021 07:28 AM