Search all worksheets

[nbaj]

Hi all,
Novice programmer so please be gentle with me! I'm running Excel 2000, and I want to search for one string in all the worksheets in a spreadsheet (there are about 20). Where do I start?
Thanks in advance..

 

[Rickster57]

search

I am using excel 2003 but will guess the following exists in 2000. At the top go to Edit>Find. Enter the string to search for using "All" or "Any part of text" and under the WITHIN drop down box choose Workbook.

 

[reclusivemonkey]

Where do I start?

With the Find Method in the VBA Help. This should tell you all you need to know about using the Find command programmatically...