wrote in message
ups.com...
On Oct 25, 3:11 pm, "SANTANDER" wrote:
I am trying to find the best way to search for a particular worksheet
name
in the spreadsheet that has many worksheets in the file (search in opened
spreadsheet). Search result need move me in to appropriate worksheet.
Some
worksheet in that workbook may have the same name, marked with 1, 2, 3..
like Name-1, Name-2, Name-3.. or Name1, Name2, etc
I appreciate any help and code samples.

Regards,
S.
------------
Hi
Activeworkbook.Worksheets("Name1").Activate

will activate the sheet called "Name1"

If the workbook is open but not necessarily active then
Workbooks("Myworkbook).Worksheets("Name1").Activat e

will do it.

It would be easy to populate a drop down menu with worksheet names for
users to pick from, if that is what you want?
regards
Paul
-------------

Yes, populating a drop down menu with worksheet names for users to pick
from(when this required only, not constantly) may be an option.
How should look this code and where it goes - inside Module1? Does this code
will count newly added worksheet also?

Regards,
Santander