Find a worksheet throu a key word

A

Anmol786

New member
Joined
Oct 7, 2014
Messages
36
Reaction score
0
Points
0
Sir

How can i find an excel worksheet entering some text only that is contained by that worksheet

warm regards
 
Code: 
For Each ws in Worksheets

    If ws.Name Like "*Mytext*" Then

        ws.ACtivate
    End If
Next ws
 
Anmol786 said:
Sir

How can i find an excel worksheet entering some text only that is contained by that worksheet

warm regards
Click to expand...


I want help in searching an excel file through entering a word

suppose i write "arif" all files containing this word should be displayed

Is that possible to find out a worksheet also

plz reply
 
I want help in searching an excel file through entering a word

suppose i write "arif" all files containing this word should be displayed

Is that possible to find out a worksheet also

plz reply But i want an excel formula only as code written by you is quite inexlicable by me
 
I want help in searching an excel file through entering a word

suppose i write "arif" all files containing this word should be displayed

Is that possible to find out a worksheet also

plz reply
 
Anmol786 said:
I want help in searching an excel file through entering a word

suppose i write "arif" all files containing this word should be displayed

Is that possible to find out a worksheet also

plz reply
Click to expand...

Firstly, don't worry about using code. You don't have to understand everything about it to use it. How many car drivers understand everything about the way a car works?
Assuming that your talking about finding a block of characters in your worksheet names, then the code that Bob has posted (#2) will do this for you after you have pressed a few keys and
copy/pasted the code to the correct place.
Can you please answer my question in post No 3, because if you are wanting to search worksheet cells for your characters, then that is a different issue altogether.
It might be advisable to post a workbook with a few examples, so that we can understand what you mean by files, i.e. workbooks or worksheets).
 
You must log in or register to reply here.
Back
Top