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