Hi,
I have hyperlinks in a sheet in Excel, for example cell A6 is linked to A101, A7 is linked to A201, and so on (the number of such hyperlinks changes dynamically, so there isn't a fixed set). The links work fine, but what happens is that it takes focus to A101 at the BOTTOM of the excel screen. Is there any way that I could make the hyperlink take the "target" cell to the TOP row of the visible Excel window?
Thank you!
Kriti

Mayby it helps you

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim WIERSZ
Dim KOLUMNA
KOLUMNA = ActiveCell.Column
WIERSZ = ActiveCell.Row
If KOLUMNA = 1 And Cells(WIERSZ, 1) <> "" Then
ActiveWindow.ScrollRow = WIERSZ
End If
End Sub

I guess you recently posted the same question and I posted the following code which was confirmed by you to have been found OK:

ActiveWindow.ScrollRow = ActiveCell.Row



Genius is 99% perspiration and 1% inspiration

yep, that worked great. i think i had posted this earlier.