+ Reply to Thread
Results 1 to 3 of 3

Check if a named range exists

Hybrid View

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

    Check if a named range exists

    Hi all

    Maybe a newbie question but I can't find the correct answer.

    How can I check if a named range exists?
    The next step would be to delete it.

    Thanks in advance
    Hein
    Last edited by Hein; 07-14-2010 at 09:19 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,979

    Re: Check if a named range exists

    Simplest method is an error handler:
    On Error Resume Next
    Activeworkbook.Names("your name here").Delete
    on error goto 0
    Everyone who confuses correlation and causation ends up dead.

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

    Re: Check if a named range exists

    Easy and a method I haven't thought of, obviously
    Thanks for your input


    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