LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 123
Default Select sheet based on cell value

Hi,

I have 25 sheet named Sheet 1 to Sheet 25.
What i am looking for is..

I need to select the specific sheet whos name is written in sheet1 A1 cell.

For example if Sheet 1 cell A1 = sheet2 and i run the macro it should take
me to sheet 2

and if Sheet 1 cell A1 = sheet14 and i run the macro it should take me to
sheet 14.

So on and so forth.

I had a similar macro but i lost it. please help me..
Thanks a lot
Boss
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using VBA select sll sheets based on Criteria on each sheet. AirgasRob Excel Discussion (Misc queries) 4 September 3rd 08 03:11 PM
Select a cell based on an other cell's value wally_91 Excel Worksheet Functions 4 March 13th 08 12:24 AM
Select sheet based on userform date input mugitty Excel Programming 4 January 22nd 06 09:37 PM
Select sheet based on reference Hans Weustink[_4_] Excel Programming 11 January 11th 05 01:05 PM
Select sheet based on cell value Dan Mills Excel Programming 2 January 14th 04 05:55 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"