Microsoft recently announced auto spillover for functions on Office 365. This automatically works if you return an array from VBA, the only caveat being that it requires an Office 365 subscription, rather than the standalone 2019 version. It would be nice if Microsoft didn’t affect spreadsheet compatibility so much between licensing models.

https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531

Leave a comment

Your email address will not be published. Required fields are marked *