GetCustomListNum Method [Excel 2003 VBA Language Reference]

  • Article

Returns the custom list number for an array of strings. You can use this method to match both built-in lists and custom-defined lists.

expression**.GetCustomListNum(ListArray)**

expression Required. An expression that returns an Application object.

ListArray   Required Variant. An array of strings.

Remarks

This method generates an error if there's no corresponding list.

Example

This example deletes a custom list.

n = Application.GetCustomListNum(Array("cogs", "sprockets", _
    "widgets", "gizmos"))
Application.DeleteCustomList n

Applies to | Application Object

See Also | AddCustomList Method | CustomListCount Property | DeleteCustomList Method | GetCustomListContents Method