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

"Ste1978" wrote in
message ...

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