Application.CustomListCount Property (Excel)
Returns the number of defined custom lists (including built-in lists). Read-only Long.
Syntax
expression .CustomListCount
expression A variable that represents an Application object.
Example
This example displays the number of custom lists that are currently defined.
MsgBox "There are currently " & Application.CustomListCount & _
" defined custom lists."