title: Paste link in vba
body: <p>I want to paste link from one sheet to another</p>
  
  <pre><code>Range("A1:D1").Select
  Range("D1").Activate
  Selection.Copy
  Sheets("Sheet2").Select
  ActiveSheet.Paste Link:=True
  </code></pre>
  
  <p>However, the code would make the sheet to switch to Sheet2 from Sheet1. Is there anyway that I could paste the link without switching the sheet?</p>
  
  <p>Thanks.</p>