How to delete most of the "custom sort list"

[newsgroup2003]

I didnt like what Excel imported now I have a lot of junk that will
take a very very long time to remove from the custom list. Is there a
way to delet them? I tried shift control and selecting the ones but
that didnt work.

Thanks

 

[Dave Peterson]

Do you want to delete all of them?

If yes, you could run a macro:

Option Explicit
Sub testme()

Dim iCtr As Long

For iCtr = Application.CustomListCount To 5 Step -1
Application.DeleteCustomList iCtr
Next iCtr

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm