| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Application.GetCustomListNum method (Excel) |
vbaxl10.chm133141 |
|
|
c4a97a96-333a-1021-7324-5cca4f0d9f3c |
04/04/2019 |
medium |
Returns the custom list number for an array of strings. Use this method to match both built-in lists and custom-defined lists.
expression.GetCustomListNum (ListArray)
expression A variable that represents an Application object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| ListArray | Required | Variant | An array of strings. |
Long
This method generates an error if there's no corresponding list.
This example deletes a custom list.
n = Application.GetCustomListNum(Array("cogs", "sprockets", _
"widgets", "gizmos"))
Application.DeleteCustomList n[!includeSupport and feedback]