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
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
Here are some attachments to show what I'm trying to do.