Good morning. I'm looking to find the name of a certain tab in my document (to make a reference point in my code) that is found by checking the first cell (1,1) of each tab for "Keywords".
Basically I have four tabs that have a bunch of info and I want the "active sheet" to become whatever sheet has "Keywords" in Cell(1,1) and for me to be able to reference that sheet later in the coding at any point. The tab name is dynamic though, as it'll change from week to week.
If I can help by being any more specific, I appreciate it!
I know that my code will eventually have to use this line of code (or something similar):
But I would have to make sure the correct tab is active and that is only by finding the keyword in R1C1
Thanks!!
Basically I have four tabs that have a bunch of info and I want the "active sheet" to become whatever sheet has "Keywords" in Cell(1,1) and for me to be able to reference that sheet later in the coding at any point. The tab name is dynamic though, as it'll change from week to week.
If I can help by being any more specific, I appreciate it!
I know that my code will eventually have to use this line of code (or something similar):
Code:
TabName = ActiveSheet.Name
But I would have to make sure the correct tab is active and that is only by finding the keyword in R1C1
Thanks!!