"Global" search in a workbook

[=?iso-8859-1?B?R/ZyZWw=?=]

I have a large workbook with several sheets with similar
contents. I need to search for various text strings in the
workbook and want to find all occurrences, regardless which
sheet they're on. The only way I have managed is to open
one sheet at a time and search for the string, which is
extremely tedious.

Is there a way to perform as "global search" in a workbook?
That would help me a lot!

Thanks,
Görel

 

[Jonathan Rynd]

Is there a way to perform as "global search" in a workbook?
That would help me a lot!

You could write a VB macro that does find on each sheet. Probably someone
has already written this, but it shouldn't be hard to do.

 

[A.W.J. Ales]

Görel,

Look for FlexFind at : http://www.bmsltd.co.uk/MVP/Default.htm

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *