That is basicly what I tried first; Search in Values, and check Search in all sheets. This is basicly what I used to do in Excel, tell it to search in values and search the whole "workbook" as it is called in Excel. Using Search in Values, Notes, or Formulas doesn't seem to help, and the search in all sheets is checked. Thanks Scott
On 5/15/06, Claudia Drechsle <[EMAIL PROTECTED]> wrote:
Hi Scott > I would like to be able to search all fields, and all sheets at once. Open the button "more options" in the find&raplace-dialogue. At the bottom of the window you'll find "search in all sheets". When the IP-Adress is the result of a formula (f.e. CONCATENATE) it might also be helpfull to activate "search in values" instead of "search in formulas" (also to find under "more options"). If you leave "search in formula", the program searches for the string within the formula instead of the result. cheers --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
