Hi All,

Is it possible to move to a specific worksheet within Excel given the
sheet's name. This is something like a "Go to Worksheet" functionality.

Thanks,
Sundar

Usually just click the tab at the bottom of the window. If there too many
tabs then this macro:

Sub marij()
Dim s As String, w As Worksheet
s = InputBox("Enter destination sheet name: ", "Go To Sheet")
For Each w In Worksheets
If w.Name = s Then
w.Activate
Exit Sub
End If
Next
MsgBox (" sheet not found")
End Sub

will do the trick. The macro can easity be modified to pick up a sheet name
in a cell as well.
--
Gary's Student


" wrote:

Hi All,

Is it possible to move to a specific worksheet within Excel given the
sheet's name. This is something like a "Go to Worksheet" functionality.

Thanks,
Sundar

Right-click on the buttons to the left of the sheet tabs for a list to choose
from.

wrote:
Hi All,

Is it possible to move to a specific worksheet within Excel given the
sheet's name. This is something like a "Go to Worksheet" functionality.

Thanks,
Sundar

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1

For a very nice macro solution see this google search thread.

http://snipurl.com/ydgp

Code by Bob Phillips.


Gord Dibben MS Excel MVP

On 7 Oct 2006 02:46:28 -0700, "
wrote:

Hi All,

Is it possible to move to a specific worksheet within Excel given the
sheet's name. This is something like a "Go to Worksheet" functionality.

Thanks,
Sundar

Gord Dibben MS Excel MVP