Hi,

1. Let's suppose that cell A1 of Sheet2 contain the myData, then in cell A1
of Sheet1 enter the formula =Sheet2!A1. This cell will now display "myData".
Now select cell A1 on Sheet1 and press Ctrl+[ This will take you to
Sheet2!A1. No VBA necessary.

2. If you like VBA here are two solutions. Name the range A1 on Sheet2
Data (just to be different) - Insert, Name, Define. In cell A1 of Sheet1
enter the text Data. Now add the following macro to the Sheet1 object:
A]

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
If Not Intersect(Target, [A1]) Is Nothing Then
Application.Goto Reference:=Target.Value
End If
End Sub

In this case you are moved to the named range when you double click the name
in cell A1. You can use many other events to trigger the macro.

B]

Sub myMove()
Application.Goto Reference:=Sheet1.[A1].Value
End Sub

This macro goes into a regular VBA module. Assign a shortcut key to this
macro and it can be executed fro any location within the workbook.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Alan Sexter" wrote:

Simon Lloyd,

I just talked with my friend from Chicago, and we would both prefer VBA.
Thanks for responding - I look forward to your upcoming response!

Alan Sexter

"Simon Lloyd" wrote:


Alan Sexter;379826 Wrote:
I am a quantitative analyst who is the leader of our department's Excel
users
group (Multi-Channel Marketing department of Eastbay, Inc. in Wausau,
Wisconsin). I have a friend who is a former co-worker in my department,
but
is now a senior credit analyst with a company in Chicago.

If possible, this credit analyst would like to have Excel take the
contents
of a cell in the workbook, and use it to select a worksheet (in that
same
workbook) that has the same name as the contents or value of that cell.
This
seems to be a "twist" on the topic of automated worksheet names that
has
generated several postings. Any help will be greatly appreciated by
both of
us. Thanks for any help that can be provided!If it is going to be a static name then it can be a hyperlink, otherwise
it would have to be done with VBA........which would you prefer?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106281