title: VBA getting the value of the cell from which a hyper link was clicked
body: <p>I am trying to send the user to a certian sheet in the workbook based on the value of the hyperlink they click on. "1.01" Is example text in one of the cells that are hyperlinks. I have the event getting triggered when they click with this code, but every time the <code>BR</code> is 0.  </p>
  
  <pre><code>Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
      Dim BR As Integer
      BR = ActiveCell.Value
      Select Case BR
      Case Is &lt; 2  'case always gets run because BR is always 0
          Worksheets("Appts").Select
      Case 2 To 3
          Worksheets("Next").Select
      Case 3 To 4
          Worksheets("Calls").Select
      End Select
  End Sub
  </code></pre>
  
  <p>I think my problem is where I am getting the <code>ActiveCell.Value</code> but I haven't been able to figure it out.  Any help is appreciated. </p>
  
  <p>Thanks,</p>