+ Reply to Thread
Results 1 to 6 of 6

Select Sheets based on named range list of sheet names

  1. #1
    Registered User
    Join Date
    12-28-2005
    Posts
    21

    Select Sheets based on named range list of sheet names

    Hello. I am trying to create a macro that would select all the sheets listed in a range. The range is called "PrintList" but when I could only get the macro to work when I have the range rather than a named range.

    How do I modify C22:C44 to be "PrintList"?


    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Select Sheets based on named range list of sheet names

    Does this work?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-28-2005
    Posts
    21

    Re: Select Sheets based on named range list of sheet names

    I tried that but received this error on that line of code

    Run-time error '1004'

    Method 'Range' of object '_Global' failed

  4. #4
    Registered User
    Join Date
    12-28-2005
    Posts
    21

    Re: Select Sheets based on named range list of sheet names

    I just tried this and it works but I'm not sure if it's the best or cleanest.

    Please Login or Register  to view this content.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Select Sheets based on named range list of sheet names

    Does this work?
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-28-2005
    Posts
    21

    Re: Select Sheets based on named range list of sheet names

    Yes! Thank you Norie! this is much cleaner.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. copying data from one sheet to named sheets based on list on third sheet
    By Caddman2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2015, 11:45 AM
  2. Loop Action on Multiple Sheets Based on Sheet Names in a Range
    By xtinct2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2014, 04:18 PM
  3. Replies: 3
    Last Post: 10-01-2014, 01:49 PM
  4. [SOLVED] Copy named sheets from one workbook to names sheet in other
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2014, 07:42 AM
  5. Code to select worksheets based on sheet names in a list
    By cdself in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2013, 01:00 PM
  6. Replies: 8
    Last Post: 07-05-2012, 09:51 AM
  7. Using sheet names as a named range
    By smileyc in forum Excel General
    Replies: 2
    Last Post: 02-06-2009, 05:40 AM

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