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.
Bookmarks