I selected a cell that would hold the hyperlink.

I hit ctrl-k (insert|hyperlink)
I chose "Place in this document".
I typed B923 in the "type the cell reference box"
(It was a single cell--the topleftcorner of the range--not a range of cells)
I finished up the hyperlink.

I added this to the worksheet module:

Option Explicit
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
On Error Resume Next
Application.Goto Application.Range(Target.SubAddress), Scroll:=True
On Error GoTo 0
End Sub

And just that single cell was selected and it was in the upper left corner of
the window.



mevetts wrote:

That was my original problem. When I click the link, it jumps to the
correct cell, but it is at the bottom of the screen, not the top. So I
then have to scroll down to view the rows.

I want it so when the link is clicked the cell to which it is linked is
displayed at the top of the screen.

Cheers,

Mark.

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

--

Dave Peterson