Find a worksheet throu a key word

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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Code:
For Each ws in Worksheets

    If ws.Name Like "*Mytext*" Then

        ws.ACtivate
    End If
Next ws
 

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


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

New member
Joined
Oct 7, 2014
Messages
36
Reaction score
0
Points
0
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
 

Anmol786

New member
Joined
Oct 7, 2014
Messages
36
Reaction score
0
Points
0
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
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
2010
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

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