+ Reply to Thread
Results 1 to 2 of 2

Determine if Named Range exists in Worksheet

  1. #1
    jkt
    Guest

    Determine if Named Range exists in Worksheet

    Any suggestions on writing code to look for a named range within a worksheet
    and if it exists, call a macro? Otherwise if named range is not found,
    continue with currenty code.

  2. #2
    Ardus Petus
    Guest

    Re: Determine if Named Range exists in Worksheet

    dim rMyrange as range

    on error resume next
    set rMyrange=Range("MyRangeName")
    on error goto 0

    if not rMyRange is Nothing then call MyMacro


    HTH
    --
    AP

    "jkt" <jkt@discussions.microsoft.com> a écrit dans le message de news:
    89F9FF2E-9A63-4A83-9D2C-A7B0DD4FD9A5@microsoft.com...
    > Any suggestions on writing code to look for a named range within a
    > worksheet
    > and if it exists, call a macro? Otherwise if named range is not found,
    > continue with currenty code.




+ 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