Hi all,
I have 3 sheets name as
1. All Status Key Process Missing
2. Open Status Key Process Mis_2
3. Ops Description Blank_3
and some times its ending name changes but there first word(All,open,Ops) not change,so i want to select these sheets using their first word like All,open,Ops. I tried the coding like
Sheets("All*").select
but it won't work
Please help me out..
thanks in advance.
Try it in this way...
Please Login or Register to view this content.
Last edited by :) Sixthsense :); 05-09-2014 at 05:14 AM.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Thank both,
Both coding works perfectly ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks