Range.SavedAsArray (Excel)

True if all of the cells in the range would be saved to file as an array formula; False if none of the cells in the range would be saved to file as a legacy array formula; null otherwise.

Dynamic array Excel may save formulas and their associated spilled cells to file as an array formula to ensure they will calculate correctly in Pre-Dynamic array versions of Excel. These cells will appear as Legacy Array formulas in Pre-dynamic array Excel.

Dim booSavedAsArray As Boolean
booSavedAsArray = ActiveCell.SavedAsArray