+ Reply to Thread
Results 1 to 2 of 2

Named Range Scope

  1. 06-12-2012, 12:44 AM #1
    OzTrekker
    OzTrekker is offline
    Forum Contributor
    Join Date
    06-18-2007
    Location
    Kiama, Australia
    MS-Off Ver
    365
    Posts
    119

    Question Named Range Scope

    Hi Folks,

    Hopefully this is a simple one.

    The following code defines the named range scope in the 'strWorksheet' Worksheet.
    How do I get it to define the named range scope in the Workbook?


    Please Login or Register  to view this content.

    Thanks,
    Craig
    Reply With QuoteRegister To Reply
  2. 06-12-2012, 02:22 AM #2
    buran
    buran is offline
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Named Range Scope

    Hi Craig,
    Add the name to the Names collection of the workbook, not the one of the worksheet.
    Please Login or Register  to view this content.
    Buran
    If you are pleased with a member's answer then use the Star icon to rate it.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1