Applies To
Application Object.
Description
Deletes a custom list.
Syntax
object.DeleteCustomList(listNum)
object
Required. The Application object.
listNum
Required. The custom list number. This number must be greater than or equal to five (Microsoft Excel has four built-in custom lists that cannot be deleted).
Remarks
This method generates an error if the list number is less than five or a matching custom list does not exist.
See Also
AddCustomList Method, CustomListCount Property, GetCustomListContents Method, GetCustomListNum Method.
Example
This example deletes a custom list.
n = Application.GetCustomListNum(Array("cogs", "sprockets", _ "widgets", "gizmos")) Application.DeleteCustomList n