PaulAsaran
New Member
- Joined
- Feb 11, 2019
- Messages
- 22
I have a single worksheet with lots of data in multiple tables. I'm looking for a way to let other users navigate to the specific data table they need. To resolve this, I created a series of hyperlinks leading to each table. This works fine, but the cell each hyperlink leads to would always be at the bottom of the screen. To resolve this, I found and used the following code:
The code works, but only for one target destination; it forces the view to switch to the specified cell regardless of which hyperlink I choose. Is there a way to modify this code to target different cells based on which hyperlink is used?
VBA Code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=Range("A36"), scroll:=True
End Sub
The code works, but only for one target destination; it forces the view to switch to the specified cell regardless of which hyperlink I choose. Is there a way to modify this code to target different cells based on which hyperlink is used?