I agree with FSt1; Find All, Within Workbook will list all results,
the worksheet/cell address and the value in a handy find table.

On Jul 30, 3:28*pm, FSt1 wrote:
hi
not to discourage you but i was wondering if you knew that this was built in
to xl.
Ctrl+F
click the options button. in the within box, select workbook.
xl will find all, and record all in the list box in the find dialog.

just wordering
regards
FSt1

"Otto Moehrbach" wrote:
Excel XP & Win XP
I have some 50 sheets in my file. *I want to find the first instance of a
particular text in whatever sheet it occurs. *Having found that, I want the
code to stop. *Then, starting from that range, I want to find the next
instance, and so forth. *I imagine a button to run a macro to find the
first, then a "Next" button to find the next.
I recorded a macro using Find over the entire workbook and the first
instance was found. *However, the initial search to find the target sheet
was not recorded, only the search within that sheet. *The recorded code
started with selection of that sheet, rather than showing the code to find
that sheet.
How would I code a search over the entire workbook starting in a given sheet
and at a given cell within that sheet? *Thanks for your time. *Otto