I have a workbook that changes the worksheet names using cells on an "inputs" tab with the following code:
Please Login or Register to view this content.
My question is, how do I activate sheets when the names change. Sheets("Sheet1").Select wouldn't work. Right?
I attached a sample...hopefully it makes sense.
Hi phelbin,
Use the sheet code name to select the tab - i.e. for the tab currently called "BLNG" you'd use this:
See here for more info.Please Login or Register to view this content.
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
The code works, but everything is out of order. I figured it would be based on the sheet order, but it seems like it might be based on the order in which I created the sheets?
Can I change that to be just the order that they appear on the bottom of the screen?
And thanks so much for your help!
If you want to select a tab (say "BLNG" to keep it consistent) based on its position (furthest left to furthest right) you'd use this:
HTHPlease Login or Register to view this content.
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks