Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Application.DeleteCustomList Method (Excel)

Published: July 16, 2012

Deletes a custom list.

expression .DeleteCustomList(ListNum)

expression A variable that represents an Application object.

Parameters

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.