Syntax

expression.DeleteCustomList(ListNum)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
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.

Visual Basic for Applications 
n = Application.GetCustomListNum(Array("cogs", "sprockets", _ "widgets", "gizmos")) Application.DeleteCustomList n
delete custom list Delete Custom List Method deletecustom DeleteCustomList DeleteCustomList Method Get rid of any specialized lists I've created

See also: