Help with code to open hidden sheets based on contents in a cell.

I have a spreadsheet that contains job titles.
When a staff member is selected their job titles are displayed vertically in cells A89:A92.
Each job title is related to a hidden worksheet with the job description on it. I want to open these hidden sheets when that job title is displayed in cells A89:A92.

I have this pieces of code which will work when searching one cell example "A89". How can I modify the code to work on all the cells. When I make the range A89:A92 the code no longer seems to work.

Please Login or Register  to view this content.