I have a search function in my Excel sheet.
The code was ok and it will highlight the cell in yellow if match. but after the search, it will go back to the dashboard sheet and results are unknown unless I check sheet by sheet, I have about 100 sheets.
How can I:-
1) Unhide the sheets where the result was found. OR
2) Display a box showing all the sheet name and row,column where the result was found.
The code was ok and it will highlight the cell in yellow if match. but after the search, it will go back to the dashboard sheet and results are unknown unless I check sheet by sheet, I have about 100 sheets.
How can I:-
1) Unhide the sheets where the result was found. OR
2) Display a box showing all the sheet name and row,column where the result was found.
Attachments
Last edited: