Hi Jitendra,
There is no VBA way to delete all of them at once but manually you can delete them very fast and efficiently. 1. Open the Name Manager (Formulas --> Name Manager(2007) or Insert-- >Name-->Define(2003)) 2. Now select the first name. 3. Now Press, Ctrl + Shift + End to select all the defined names. 4. Click on Delete. Hope this solves your problem efficiently. Do remember this action cannot be replicated in VBA. VBA will perform action on individual name at a time. ________________________________________ Thanks & Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ________________________________________ On Sep 24, 11:51 am, "Jitendra Kumar Verma" <jitendra.ve...@globallogic.com> wrote: > Hi All, > > I have 30000+ defined names in workbook and want to delete it. > > I have written code below, > > Dim nm as name > > For each nm in activeworkbook.names > > Nm.delete > > Next > > But it takes too much time to delete. > > Is there any other way to faster delete the all defined names from > workbook. > > Thanks > > Jitendra Kr. Verma -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
