Hello. I am trying to write a macro that will will send the user to a WorkSheet name where the worksheet name is the value in a specific cell.
If I already knew the sheetname, I know I can use something like:
Sheets("Sheet1").Select
But the sheetname will be cell the value that is in b1, but and that value (name) that appears in b1 may be different each time the macro is run.
So trying to have the macro check for the value in b1 and then send user to the sheetname that equals that value.
Appreciate any suggestions. Thanks very much!
- Mike G
Bookmarks