Author Topic: Excel: Additional FIND Functionality Routine  (Read 3704 times)

0 Members and 1 Guest are viewing this topic.

M-dub

  • Guest
Excel: Additional FIND Functionality Routine
« on: November 02, 2004, 09:34:23 AM »
*I'm tempted to put this in the Office Software Forum, but I think I'll just put a link to it in there instead...*
I want to create a routine that will enable me to find text within an entire workbook as opposed to a single sheet (tab).
It seems to me that this should be fairly simple...I just need a little 'kickstart'  :oops:

Anyone out there feel like helping me out a bit?

Thanks a lot,
Mike

M-dub

  • Guest
Excel: Additional FIND Functionality Routine
« Reply #1 on: November 02, 2004, 10:23:24 AM »
Never mind...

Solution Found:
Right Click on one tab and 'Select All Sheets'
Then use CTRL+F as you normally would.  When it finds the text, Excel automatically selects the tab that it was found on.