VBA - Detect Cell/Range of Hyperlink that was clicked

[bs0d]

How can I get the reference of the cell that contains a hyperlink that was triggered? This may not be equal to the ActiveCell.

--or-- detect the hyperlink destination. In my scenario, they are the same.


Thanks,

 

[Gary McMaster]

Maybe this?

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Debug.Print Target.Parent.Address
Debug.Print Target.Address

End Sub

 

[bs0d]

Maybe this?

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Debug.Print Target.Parent.Address
Debug.Print Target.Address

End Sub

Target.Parent.Address

did the trick. Thanks!