DataPig posted about Custom Lists in Excel and his inability to delete them. I agree on all points; I’ve never needed Sun-Sat and we should be able to delete them if we want.
Here’s a macro to list all the Custom Lists to the Immediate Window.
Dim i As Long, j As Long
Dim sList As String
Dim vList As Variant
For i = 1 To Application.CustomListCount
vList = Application.GetCustomListContents(i)
sList = “”
For j = LBound(vList) To UBound(vList)
sList = sList & vList(j) & “,”
Debug.Print i, UBound(vList), sList
Apparently I’ve used custom lists in the past because there are two there that I made. Number 5 is clearly payroll item types from Quickbooks, but I don’t recall why I would put them in a Custom List. And the last one is the first 9 days of every month of the year; also a complete mystery as to why I would need that.