Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To go to a particular Sheet
Dear Garys,
I got the solution from just a few lines of code provided by u. thanks a tonn for the same. Akash On Dec 23, 5:01 pm, Gary''s Student wrote: Look at this one-liner: SubAkash() Sheets(Selection.Value).Activate End Sub 1. assign a shortcut key to this macro 2. click on ANY cell that contains a tab name (worksheet name) 3. run the macro an you go to that tab This tiny macro will work on cells in any row or any column in any sheet. -- Gary''s Student "Akash" wrote: Hi, In Excel Workbook I have 5 Sheets with Different Names. I had accumulated 5 Names in Sheet1 in Column A COIL CATCHER DOOR - INSULATED DOOR - UNINSULATED DOOR LOCK STRIP GI - Z Now i want that if i place my cursor to the Cell No: A5 (GI - Z) and press a shortcut key then the cursor should go to that Sheet whose name is (GI - Z). Is this Possible. If this can be done then it would be a very handy toold for me. Thanks In Advance. AkashMaheshwari |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
To go to a particular Sheet
You are very welcome !
-- Gary's Student "Akash" wrote: Dear Garys, I got the solution from just a few lines of code provided by u. thanks a tonn for the same. Akash On Dec 23, 5:01 pm, Gary''s Student wrote: Look at this one-liner: SubAkash() Sheets(Selection.Value).Activate End Sub 1. assign a shortcut key to this macro 2. click on ANY cell that contains a tab name (worksheet name) 3. run the macro an you go to that tab This tiny macro will work on cells in any row or any column in any sheet. -- Gary''s Student "Akash" wrote: Hi, In Excel Workbook I have 5 Sheets with Different Names. I had accumulated 5 Names in Sheet1 in Column A COIL CATCHER DOOR - INSULATED DOOR - UNINSULATED DOOR LOCK STRIP GI - Z Now i want that if i place my cursor to the Cell No: A5 (GI - Z) and press a shortcut key then the cursor should go to that Sheet whose name is (GI - Z). Is this Possible. If this can be done then it would be a very handy toold for me. Thanks In Advance. AkashMaheshwari |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |