| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Application.DeleteCustomList method (Excel) |
vbaxl10.chm133117 |
|
|
41a936f7-05b5-520f-f5c5-172a5ea124d9 |
04/04/2019 |
medium |
Deletes a custom list.
expression.DeleteCustomList (ListNum)
expression A variable that represents an Application object.
| 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). |
This method generates an error if the list number is less than 5 or if there's no matching custom list.
This example deletes a custom list.
n = Application.GetCustomListNum(Array("cogs", "sprockets", _
"widgets", "gizmos"))
Application.DeleteCustomList n[!includeSupport and feedback]