Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

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.
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

There is an option in the List menu to convert to a range.
Avatar of Sandra Smith

ASKER

It must be done in the VBA code.
ASKER CERTIFIED SOLUTION
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The only change was to make unlist delete and it works.  Thank you

Sandra