+ Reply to Thread
Results 1 to 6 of 6

VBA code to activate second-to-last and last worksheet tabs in a workbook?

  1. 12-11-2008, 03:44 PM #1
    Nickster64
    Nickster64 is offline
    Registered User
    Join Date
    11-06-2008
    Location
    Illinois
    Posts
    63

    Question VBA code to activate second-to-last and last worksheet tabs in a workbook?

    I use a workbook where new worksheet tabs are added and removed daily. Every day I use the second-to-last tab (2nd from the right) and the last tab (far right).

    What code would enable me to activate and reference both of these tabs individually?

    I believe it would be something like the code below but I can't figure it out... 

    Please Login or Register  to view this content.
    Thanks!

    Nick
    Last edited by Nickster64; 12-12-2008 at 11:11 AM.
    Reply With QuoteRegister To Reply
  2. 12-11-2008, 03:48 PM #2
    ChrisMattock
    ChrisMattock is offline
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    Last Sheet:
    Please Login or Register  to view this content.
    2nd to Last Sheet:
    Please Login or Register  to view this content.
    Last edited by ChrisMattock; 12-11-2008 at 03:51 PM.
    Reply With QuoteRegister To Reply
  3. 12-11-2008, 03:52 PM #3
    Nickster64
    Nickster64 is offline
    Registered User
    Join Date
    11-06-2008
    Location
    Illinois
    Posts
    63
    Thanks Chris that worked well. Do you know how to activate the second-to-last sheet as well?

    -nick
    Reply With QuoteRegister To Reply
  4. 12-11-2008, 03:53 PM #4
    ChrisMattock
    ChrisMattock is offline
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    Yeh dude, just check out the above! Or... here it is again. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-11-2008, 03:57 PM #5
    Nickster64
    Nickster64 is offline
    Registered User
    Join Date
    11-06-2008
    Location
    Illinois
    Posts
    63
    Ah...thanks! It didn't show up the first time but I have it now.

    Best,

    Nick
    Reply With QuoteRegister To Reply
  6. 12-11-2008, 04:01 PM #6
    ChrisMattock
    ChrisMattock is offline
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    No probs. Anytime.
    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