Dave

I have never had any luck finding text in *.xls files using the Windows search.

Agent Ransack never fails me.

http://www.mythicsoft.com/agentransack/

Freeware and easy to install and use.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 11:56:00 -0700, Dave Birley
wrote:

Somewhere among the 50 or so WBs that I have on the Flash drive at the
moment, there is a macro I wrote which uses a nice Select Case system to do
some dirty work. Now I wold like to get back to it so I can hack it for a new
job rather than reinventing that particular wheel.

I tried doing a reqular Windows Search for files with ".xls" in their name
and for "Select Case" as content. Didn't find a one.

I'll bet there is a way (Excel 2003, BTW). Hayullpppp!