xl2002 offers a find in workbook (under the Options button on the Edit|Find
dialog).

Then you can click on the line in the results window to go to that location.

I had to search for that site:

http://www.theupdown.com/

where you can "play" with investments.

wrote:

Hey, I have a workbook with many worksheets. I am trying to write a
macro to search all the worksheets for a unique value. I have a
userform to enter the value and assign it to a variable. I just need
to search all sheet for that string, and if that string exists in a
worksheet, activate that worksheet. Anyone done anything like this?
Can you help?

--

Dave Peterson