Share via


Application.GetCustomListNum Method (Excel)

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.

Syntax

expression .GetCustomListNum(ListArray)

expression A variable that represents an Application object.

Parameters

Name

Required/Optional

Data Type

Description

ListArray

Required

Variant

An array of strings.

Return Value

Long

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

See Also

Concepts

Application Object

Application Object Members