Skip to main content
Row

DefinedNameCollection Methods

A collection of defined names stored in a worksheet or workbook.
Name Description
Add(String, String) Adds a new defined name to the end of the collection and returns the newly created object.
Clear() Removes all defined names from the collection.
Contains(DefinedName) Indicates whether the collection contains the specified defined name.
Contains(String) Indicates whether the collection contains the defined name with the specified DefinedName.Name property value.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetDefinedName(String) Returns the DefinedName object with the specified DefinedName.Name property value.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(DefinedName) Returns the position of the defined name in the collection.
Remove(DefinedName) Removes the specified defined name from the collection.
Remove(String) Removes the defined name with the specified name from the collection.
RemoveAt(Int32) Removes the defined name at the specified index location from the current collection.
See Also