Hi Fybo,

Look at Jan Karel Pieterse's excellent FlexFind addin which is freely
downloadable at:

http://www.jkp-ads.com/Download.htm


---
Regards,
Norman



"Fybo" wrote in message
...
Hi,

Is it possible to search for text in multiple worksheets within the one
workbook in Excel 97 (I know, my company is woefully out of date!!)?

I have 13 worksheets and want to search for a person's name or a reference
number in the entire workbook so that it will go directly to the worksheet
and cell.

Ctrl+f cannot do this and I've tried FIND, SEARCH all to no avail.

Any ideas??

Many thanks in advance.

Fybo.