Skip to main content

ArrayFormulaCollection Methods

A collection of ArrayFormula objects.
Name Description
Add(CellRange, String) Creates a new array formula and adds it to the collection.
Clear() Clears all array formulas.
Contains(ArrayFormula) Determines whether the collection contains the specified formula.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(ArrayFormula) Returns the zero-based index of the specified element in the collection.
Remove(ArrayFormula) Clears the ranges containing the specified array formula.
Remove(CellRange) Clears the array formula in the specified range.
RemoveAt(Int32) Removes the element at the specified index of the ArrayFormulaCollection instance.
See Also