Results 1 to 5 of 5

Thread: Selecting Excel tabs - without tab name

  1. Dec 5th, 2005, 04:44 PM #1
    TommyHawk
    TommyHawk is offline

    Thread Starter
    Member
    Join Date
    Mar 2005
    Location
    Seattle
    Posts
    56

    Selecting Excel tabs - without tab name

    How can a macro select "all" tabs (or specific ones) without having to write in each tab name? My tab names might change, so I'd like to be able to select them all, or select sheets #2-6, 8, 11-21, etc., and print?

    Thanks much!
    Reply With Quote Reply With Quote
  2. Dec 5th, 2005, 04:54 PM #2
    john24
    john24 is offline
    Addicted Member
    Join Date
    Jan 2003
    Posts
    163

    Re: Selecting Excel tabs - without tab name

    worksheets can be refered to by index as well as by name
    Reply With Quote Reply With Quote
  3. Dec 6th, 2005, 07:14 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Selecting Excel tabs - without tab name

    Moved to Office Development.
    Reply With Quote Reply With Quote
  4. Dec 6th, 2005, 09:50 AM #4
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Selecting Excel tabs - without tab name

    VB Code:
    1. Sheets(Array(1,3,5,7,8)).Select

    2. ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  6. Dec 6th, 2005, 01:55 PM #5
    TommyHawk
    TommyHawk is offline

    Thread Starter
    Member
    Join Date
    Mar 2005
    Location
    Seattle
    Posts
    56

    Re: Selecting Excel tabs - without tab name

    So simple! Thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width