title: Target.Range.Offset - or something like that
body: <p>I'm trying to accomplish that if you click on a hyperlink (in column P), it would copy the cell in the same row but in column B to another cell (A3).</p>
  <p>I'vre tried with the Target.Range. Offset and other ways. But I can't seem to figure it out.</p>
  <p>But I just can't get it right. Here's the code, any ideas?</p>
  <pre><code>Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
      If Target.Range.Address = &quot;$A$4&quot; Then
         MsgBox &quot;This shouldn't happen... Try again&quot;
      Else
          Dim TargetCell As Range
          Set TargetCell = Target.Range
          TargetCell.Offset(-13, 0).Copy
          Range(&quot;Vraagnummer&quot;).PasteSpecial Paste:=xlPasteValues
              Application.CutCopyMode = False
          
          Exit Sub
      End If
  
  End Sub
  </code></pre>