title: How to paste a link to a worksheet?
body: <p>All of the variables are defined correctly. This works till it gets to the final statement shown and then it says</p>
  <blockquote>
  <p>&quot;Paste method of Worksheet class failed&quot;.</p>
  </blockquote>
  <pre class="lang-vb prettyprint-override"><code>Set TargetSheet = ActiveSheet
  For Each cell In TargetSheet.Columns(1).Cells
      If IsEmpty(cell) = True Then FirstRow = cell.Row: Exit For
  Next cell
  LastRow = FirstRow + 6
  
  Sheets(ClientName).Range(&quot;A3:Q9&quot;).Copy
  
  With Sheets(&quot;4 Policies&quot;)
      .Activate
      .Range(&quot;A&quot; &amp; FirstRow).Select
      ActiveSheet.Paste Link:=True
  End With
  </code></pre>