Target cell vs specific cell

[Terrific]

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

[Terrific]

Here are some attachments to show what I'm trying to do.