shahdelsol
Active Member
- Joined
- Jul 21, 2009
- Messages
- 276
- Office Version
- 365
- Platform
- Windows
I am looking for macro that searches for the name of the tab in the data of the sheet and if found it turns it in bold and highlights it in red.
Let's say the name of sheet/tab is 0123456, I would like to look for 0123456 or 123456 in the sheet and if found , make it bold and red and if not found the popup would say no match found. The name of tab is usually a number that sometimes starts with zero(s), if that matters. However the zeros may or may not appear in the data itself. I appreciate that anyone can help!
Let's say the name of sheet/tab is 0123456, I would like to look for 0123456 or 123456 in the sheet and if found , make it bold and red and if not found the popup would say no match found. The name of tab is usually a number that sometimes starts with zero(s), if that matters. However the zeros may or may not appear in the data itself. I appreciate that anyone can help!
Last edited: