Search for values, create a list and show in message box

[gokica]

Hi,

I have a file containing a lot of sheets. Some of them contain an error.

I would like to have a macro that will search through the file and detect in which sheets there are errors.

At the end of the search I would like a list with the spreadsheet's labels that contain errors to show up so that I can locate them manually.

The error can be found easily. If cells A1 and/or A2 contain a text or a value than there is error. If these two cells are blank than that sheet is correct and it should not be in the list.

Thank you so much for your help with this matter.

[walruseggman]

Please Login or Register  to view this content.

[gokica]

Please Login or Register  to view this content.

Wonderful.

Since I am running the macro from another file I just replaced ThisWorkbook with ActiveWorkbook.

And it works perfectly. Thank you so much.