View Full Version : Search all worksheets


nbaj
12-12-2005, 01:47 AM
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
12-12-2005, 06:00 AM
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
12-12-2005, 06:40 AM
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...