Results 1 to 4 of 4

How to Delete ALL Defined Names in a WorkBook Dynamically created from a Single Sheet

Threaded View

e4excel How to Delete ALL Defined... 04-16-2011, 04:02 PM
e4excel Re: How to Delete ALL Defined... 04-16-2011, 04:38 PM
mikerickson Re: How to Delete ALL Defined... 04-16-2011, 05:43 PM
e4excel Re: How to Delete ALL Defined... 04-17-2011, 03:23 AM
  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,522

    How to Delete ALL Defined Names in a WorkBook Dynamically created from a Single Sheet

    How to Delete ALL Defined Names in a WorkBook Dynamically created from a Single Sheet?

    I am creating some Files or WorkBooks Dynamically everything is fine however the purpose of creating this is to just have the Data BacK up with only Values and Formatting and No Formulas...

    But after checking the New WorKBook it has all the Defined Names from the Parent MasterSheet..

    IS is t possible to delete ALL the Defines Names when it is being created ?

    While GOOGLING on this issue I found some code which I tried in vain..
    http://www.ozgrid.com/forum/showthre...t=20268&page=1

    Richie's Code

    Sub RemoveNames()
    Dim nm As Name
    Dim NewWkBkName As String ' My New Line
    NewWkBkName = Sheets("PassBook").Range("U5").Value ' My New Line

    For Each nm In NewWkBkName.Names 'ThisWorkbook.Names
    nm.Delete
    Next nm
    End Sub
    Just to explain where Im going wrong Im enclosing it in Quotes..please excuse..!

    I am unable to attach a WorkBook as the file contains all confidential information so please pardon me for the same.

    Warm Regards
    e4excel
    Last edited by e4excel; 04-17-2011 at 03:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1