GetCustomListNum Method

Microsoft Excel Visual Basic

GetCustomListNum Method

       

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