Is it possible to search tabs in excel?

[Ste1978]

Hi,

I know if you press 'ctrl + F' you can search for a specific word in
spreadsheet, but is there a way to search for a specific word in th
tabs at the bottom? I have a spreadsheet that has 100's of tabs at th
bottom.

Any ideas?

St

 

[Guest]

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.

 

[Don Guillett]

try
Sub searchpages()
For Each ws In Worksheets
If InStr(UCase(ws.Name), "JOE") > 0 Then ws.Select
Next
End Sub