DeleteCustomList Method
Deletes a custom list.
expression.DeleteCustomList(ListNum)
expression Required. An expression that returns an Application object.
ListNum Required Long. The custom list number. This number must be greater than or equal to 5 (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 5 or if there's no matching custom list.
Example
This example deletes a custom list.
n = Application.GetCustomListNum(Array("cogs", "sprockets", _
"widgets", "gizmos"))
Application.DeleteCustomList n