Display certain cell as the top left most cell

  • Thread starter Thread starter rslc
  • Start date Start date
R

rslc

Hi I have a hyperlink formula as below which matches and selects a cell on
another worksheet based on contents of c17. Can this formula be extended to
show selected cell at the top left of spreadsheet
any help much appreciated thanks

rslc

=HYPERLINK("#'validationlists'!a" & MATCH(C17,validationlists!A1:A472,0),
C17)
 
If you use the Inserted Hyperlink rather than the function, you can take
advantage of event macros:

This event macro, insterted in the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Dim s As String
s = ActiveCell.Address(ReferenceStyle:=xlR1C1)
Application.Goto Reference:=s, Scroll:=True
End Sub

will scroll the window after the jump.
 
Back
Top