Excel.SpillErrorCellValueSubType enum
Represents types of #SPILL! errors.
Remarks
Fields
collision = "Collision" | An error caused by a dynamic array attempting to spill data into a cell that isn't empty. Displays as error type #SPILL! in Excel. |
indeterminateSize = "IndeterminateSize" | An error caused by a dynamic array formula that can't be evaluated in a single calculation. Displays as error type #SPILL! in Excel. |
mergedCell = "MergedCell" | An error caused by a merged cell blocking a dynamic array. Displays as error type #SPILL! in Excel. |
outOfMemoryWhileCalc = "OutOfMemoryWhileCalc" | An error caused by insufficient memory when attempting to calculate a dynamic array formula. Displays as error type #SPILL! in Excel. |
table = "Table" | An error caused by entering a dynamic array formula in a table. Displays as error type #SPILL! in Excel. |
unknown = "Unknown" | An unknown type of error. Displays as error type #SPILL! in Excel. |
worksheetEdge = "WorksheetEdge" | An error caused by a dynamic array attempting to spill over the edge of the worksheet. Displays as error type #SPILL! in Excel. |
Office Add-ins