Sandra Smith
asked on
Delete a named LIST in Excel
I have a VBA process that creates several lists on an Excel 2003 worksheet. Naturally, they are used to filter data for review. However, sometimes the list needs to be refreshed. Since the list is created in code with a name assigned, is there a way to delete a list that is named? Say I have a list that is created in code with the name DATAMES, I need delete this named list. This is NOT a named range! this is a named list.
There is an option in the List menu to convert to a range.
ASKER
It must be done in the VBA code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The only change was to make unlist delete and it works. Thank you
Sandra
Sandra