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?
Bookmarks