Finding Target Info From Hyperlink

I have created a list of projects which have hyperlinks. When the hyperlink is clicked, I run an excel macro to display the project details in a pdf. However, I am having a problem knowing which project is selected so I can get the correct project details.

My list is in columns B and C.

Project #
Select Project

9
Project 9

14
Project 14

21
Project 21

I create the hyperlinks here:

For i = 7 To 96
If wshS.Cells(i, 10).Value = "Y" Then
' Copy cell values
wshT.Cells(j, 2).Value = wshS.Cells(i, 1).Value
wshT.Cells(j, 3).Value = wshS.Cells(i, 2).Value
ActiveSheet.Hyperlinks.Add Anchor:=wshT.Cells(j, 3), Address:="", SubAddress:=wshT.Cells(j, 3).Address, TextToDisplay:=wshT.Cells(j, 3).Text
j = j + 1
End If
Next i

When the hyperlink is clicked, I need to find the project # to retrieve the project information. The project number is in the cell to the left of the hyperlink. I want to place that value into PrintFilter.

Currently this line: PrintFilter = wshT.Cells(Target.Row, 2).Value receives the message, error 438 object doesn't support this property or method.

If I place the number in PrintFilter, the macro runs successfully. That is the PrintFilter = 9 below.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Dim PrintFilter As Integer
Dim wshT As Worksheet
Dim wshTemp As Worksheet
Dim wshTemp2 As Worksheet

[Code] ....