Nevermind. I feel stupid now. Just select all the spreadsheets you want to
search for. I tried this, but I forgot the B was part of the custom format,
in order to keep the cell a number.

"Sloth" wrote:

> I am trying to search for specific string throughout an entire workbook. I
> have multiple (50+) worksheets in my file. I want to be able to search the
> entire workbook for any cell that contains B836004. Do I need to open and
> search each sheet at a time, or is there a quicker way?