TheSwamp

Code Red => VB(A) => Topic started by: M-dub on November 02, 2004, 09:34:23 AM

Title: Excel: Additional FIND Functionality Routine
Post by: M-dub 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
Title: Excel: Additional FIND Functionality Routine
Post by: M-dub 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.