Search all worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jneaves@clemson.edu - 12 Sep 2007 21:29 GMT

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?

Reply to this Message

Dave Peterson - 12 Sep 2007 22:43 GMT

Check your other post, too.

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

Signature

Dave Peterson

Reply to this Message