Search for a value in the tabs and give the tab names in return

Hello to all,

I have a problem with the search macro below which allows me to search for a value in the entire workbook.
Except that it only returns the name of the first tab found and I would like to know all the tabs where the basic data is located.

Thank you very much in advance,
Benten667

Please Login or Register  to view this content.

Hello,

so obviously just removing the Exit Sub codeline …

Hello,

Thank you for taking the trouble to answer me, indeed by removing this part it allows to have the information by tab.

I may have misspoken but what I would like is that a list be generated without having to click to change tabs.

Thanks in advance!