Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Login
Register
TheSwamp
»
Code Red
»
VB(A)
»
Topic:
Excel: Additional FIND Functionality Routine
« previous
next »
Print
Pages: [
1
] |
Go Down
Author
Topic: Excel: Additional FIND Functionality Routine (Read 3818 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'
Anyone out there feel like helping me out a bit?
Thanks a lot,
Mike
Logged
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.
Logged
Print
Pages: [
1
] |
Go Up
« previous
next »
TheSwamp
»
Code Red
»
VB(A)
»
Topic:
Excel: Additional FIND Functionality Routine