Find in more than 2 workbooks

[bollam hudson]

Hi all-I have been wondering if some one could help me how to "search/Find " value or text in more than 2 work books with multiple sheets in each book .?

[Kevin#]

This searches one folder and cell values
Input boxes lead you through.
(so if searching for "TEXT", and the cell value is "text" or "Text" etc, that will be found, but if cell value "cell text" it will not be found)
Amend the code to suit your specific requirement
At the moment, results fed back through message box, but if you want something to happen when cell is found, amend the code where indicated.

Please Login or Register  to view this content.