+ Reply to Thread
Results 1 to 5 of 5

deleting named ranges

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Posts
    201

    deleting named ranges

    Hi all,

    I'm looking for a way to delete all named ranges starting with ProfitCenter

    The macrorecorder doesn't give me any clues.

    Thanks in advance
    Hein
    Last edited by Hein; 01-28-2009 at 09:28 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: deleting named ranges

    In what sense does the macro recorder not help.

    Please Login or Register  to view this content.
    You will have to expand on what you mean by "all named ranges starting with ProfitCenter". What is special about the start point? Are there names that should be left alone?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-29-2005
    Posts
    201

    Re: deleting named ranges

    Hi Andy
    Thanks for your reply

    Names will look like ProfitCenter_1, ProfitCenter_2 etc

    Will changing your code to
    Please Login or Register  to view this content.
    help?

    Hein

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: deleting named ranges

    No that would error.

    You need something more like this,

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-29-2005
    Posts
    201

    Re: deleting named ranges

    OK, got it

    Thanks Andy

    Hein

+ Reply to Thread

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