Hi,
I know if you press 'ctrl + F' you can search for a specific word in a spreadsheet, but is there a way to search for a specific word in the tabs at the bottom? I have a spreadsheet that has 100's of tabs at the bottom.
Any ideas?
Ste
Hi,
I know if you press 'ctrl + F' you can search for a specific word in a spreadsheet, but is there a way to search for a specific word in the tabs at the bottom? I have a spreadsheet that has 100's of tabs at the bottom.
Any ideas?
Ste
Hi
You could try this page:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Which has a macro for creating an index page, with clickable shortcuts to
each sheet.
An alternative, but similar method, is to download ASAP Utilites' Excel
Add-in from www.asap-utilities.com
This has this function and many, many others.
Andy.
"Ste1978" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I know if you press 'ctrl + F' you can search for a specific word in a
> spreadsheet, but is there a way to search for a specific word in the
> tabs at the bottom? I have a spreadsheet that has 100's of tabs at the
> bottom.
>
> Any ideas?
>
> Ste
>
>
> --
> Ste1978
> ------------------------------------------------------------------------
> Ste1978's Profile:
> http://www.excelforum.com/member.php...o&userid=32398
> View this thread: http://www.excelforum.com/showthread...hreadid=550917
>
try
Sub searchpages()
For Each ws In Worksheets
If InStr(UCase(ws.Name), "JOE") > 0 Then ws.Select
Next
End Sub
--
Don Guillett
SalesAid Software
[email protected]
"Ste1978" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I know if you press 'ctrl + F' you can search for a specific word in a
> spreadsheet, but is there a way to search for a specific word in the
> tabs at the bottom? I have a spreadsheet that has 100's of tabs at the
> bottom.
>
> Any ideas?
>
> Ste
>
>
> --
> Ste1978
> ------------------------------------------------------------------------
> Ste1978's Profile:
> http://www.excelforum.com/member.php...o&userid=32398
> View this thread: http://www.excelforum.com/showthread...hreadid=550917
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks