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

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