Terrific
06-08-2020, 02:02 PM
How do I modify this code so that it points to the target cell instead of C9?
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Not Intersect(Target.Parent, Range("C9")) Is Nothing Then
Paste_Link
End If
End Sub
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Not Intersect(Target.Parent, Range("C9")) Is Nothing Then
Paste_Link
End If
End Sub