Search all worksheets (1 Viewer)

N

nbaj

New member

Local time

Today, 10:05

Joined

Dec 3, 2004

Messages

6

• Dec 12, 2005

• #1

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..

 

R

Rickster57

Registered User.

Local time

Today, 02:05

Joined

Nov 7, 2005

Messages

431

• Dec 12, 2005

• #2

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

Registered User.

Local time

Today, 10:05

Joined

Oct 5, 2004

Messages

749

• Dec 12, 2005

• #3

nbaj said:

Where do I start?

Click to expand...

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